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 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor 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
    1. Kuchulu
       
      Yes, that's it.

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