Finding a specific value in a spreadsheet and displaying a corresponding value if found.

I have a spreadsheet with names in columns a, c, and e with corresponding values in columns b, d, and f.

I am trying to ask the program to look for a specific name in column a. If the name is found, the value in the corresponding column b should be displayed.

For example, if the name John Doe appears anywhere in column a (let's say cell a6), display the corresponding value in column b (in this case, b6).

Thank you in advance,

Sean

Suppose the name you are looking for is in G1, then you could use this formula in H1:

=IF(COUNTIF(A:A,G1)>0,VLOOKUP(G1,A:B,2,0),IF(COUNTIF(C:C,G1)>0,VLOOKUP(G1,C:D,2,0),IF(COUNTIF(E:E,G1)>0,VLOOKUP(G1,E:F,2,0),"Not present")))

Hope this helps.

Pete

Fantastic!!

Thanks for the quick response.