View original (French)

IF function for a range of data

Solved
Kuchulu -  
 benji -
Hello,

I have a formula problem.
In cell B2 I have the code AOM7630601176, I would like to know if in another file in the range from B2 to B248 this code exists, and if so, write the amount from cell C2 into J2.
I have tried in different ways with the IF function but the fact that it is a range of data and not just a single cell is causing me issues.

Thank you for your help

Configuration: Windows / Chrome 55.0.2883.87

1 réponse

Réponse 1 / 1
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
Hello
try using COUNTIF in J2

=IF(COUNTIF(range address;B2);C2;"")

best regards

--
The quality of the answer mainly depends on the clarity of the question, thank you!
3
Kuchulu
 
Yes, that's it.

Thank you very much!
0
benji
 
Thank you very much from two junior data scientists.
0