Comparing 3 columns?

[cthompson17]

How do I compare a value in one cell, to a value in a column, that looks at
the value in the adjacent column, to display in a cell?

For example: cell A1 = cindy; column B in cell B17 = cindy; and in the
adjacent cell, column C17 = 777. I would like the value of cell C17 to
display in a cell.

Does anyone know how to do this?

 

[Ms-Exl-Learner]

=VLOOKUP(A1,B:C,2,FALSE)

Remember to Click Yes, if this post helps!

 

[cthompson17]

It's not working.....I keep trying, but nothing.
Suggestions?

I want to match the cell value in column A with the value in column B.
The value in each cell in column B relates to a unique identifier in column C.
So, in whatever formula, it first looks at A1, then tries to find a match in
column B. Once the match is found, it returns the value in a blank cell of
the value in column C - which is adjacent to column B.

Does that make sense?

 

[Fred Smith]

The formula should do what you asked for. Why don't you tell us what you
"keep trying", and more detail on what's "not working".

Regards,
Fred

 

[cthompson17]

SUCCESS!!!!!
Thank you guys, that worked.
Not sure what was going wrong last night, but it works prefectly now!!

 

[Fred Smith]

Glad to help. Thanks for the feedback.

Regards,
Fred