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