Comparing 3 columns?

  • Thread starter Thread starter cthompson17
  • Start date Start date
C

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?
 
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?
 
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
 
SUCCESS!!!!!
Thank you guys, that worked.
Not sure what was going wrong last night, but it works prefectly now!!
 
Back
Top