need for a function similar to "FIND"

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
 
D

Domenic

Hi Sue,

You can use the VLOOKUP function for that. Try,

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

Hope this helps!
 
D

Don

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

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

Don
 

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

Find value based on two lookup values 2
Conditional Formatting from a group 6
Function for summing or counting cells based on a specified fill color 3
Finding the right style field in VBA 0
Conditional Formatting with VBA 4
Sorting Columns Values question 2
Match 2 Columns, Return 3rd, Differing Match Types 3
Multiple Criteria Find & Replace 3

Top