Comparing 3 columns?

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?
 
C

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?
 
F

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
 
C

cthompson17

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
IF function possible? 4
IF statement to calculate based on cell values 7
Using IF functions to calculate shipping cost and methods 1
Event recognition. 6
Yes or blank, depending if value equals or exceeds value found inVLookup table. 4

Top