need for a function similar to "FIND"

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I would like to imbed a "find" function within an excel
cell so that when I enter data in this cell it will return
the contents of another cell.
Example:
A B
1
2 10 Red
3 15 Blue
4 20 Green
5 25 White
I would like to be able to enter the value 15 in cell A1
and get "Blue" as a response in cell B1
 
Hi Sue,

You can use the VLOOKUP function for that. Try,

=VLOOKUP(A1,A2:B5,2,0)

Hope this helps!
 
Sue, Assuming you're talking about the word "Blue" and
not the background color of the cell, try this:

=IF(A1=15,"Blue","")

Don
 
Back
Top