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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Conditional formatting to test blank text cell 4
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Select multiple adjacent cells of multiple cells without selecting 7
Event recognition. 6
IF statement to calculate based on cell values 7
IF function possible? 4
Dragging values down a range using a colum to determine its length 4

Back
Top