IF Function formula

[Leonj79]

Hi, I need help on how to do the following.

in range A1:A200 i have a list of check numbers, consolidated with the bank statements, but i have information with the same check number with the comment included, what i want to do is match the comment with the exact check number on the consolidated bank statement file.

ei: in A1 i have check number 2143 which is payble to jhon anderson amount of US$ 2000.00 (here is where i want to include what this person did the comment).


Thank you.

[arthurbr]

You probably need the VLOOKUP function