Lookup between 2 sheets

[leebauman]

Hello,

I have a 2-worksheet book. In the first sheet is something like the following:

column 1 column 2
A red
B blue
C green
D yellow

In the 2nd sheet I have column 1 with some details - I would insert the letter corresponding to the color in column 2 and would like the name of the color to appear in column 3.

column 1 column 2 column 3
roof D ??
door C ??
window D ??
floor B ??

What formula needs to be entered in column 3? Thanks very much!

 

[Andrew Poulsom]

Try:

=VLOOKUP(B1,Sheet1!A:B,2,FALSE)

 

[Jonmo1]

Try Index / Match

in the 2nd sheet, column 3
=INDEX(Sheet1!B:B,MATCH(B1,Sheet1!A:A,0))

Hope this helps..

 

[leebauman]

Thank you. That worked for the simple example I gave in my post. The worksheet Im workingn with is more complex though and Im having trouble getting it to work. Would it matter if the value being looked up was entered in the 1st worksheet as a formula?

Thanks.

 

[Jonmo1]

Depends on that formula, and what it's results are..

I'm gonna take a guess that the formula you have for the lookup value is returning a "Number Stored As Text" Value, not a real number. But the data you're looking IN is actual numbers. That happens alot...
Perhaps adding *1 to the end of whatever your formula is will help...

 

[leebauman]

In my attempt to simplify, I made things more confusing Here's what I actually have
Sheet 1
A B
Price Code $5 (formula value, =C1*.25)
A $10
B $25
C $50
D $75
E $90

Sheet 2
A B C
City Enter price code here (i.e. "C") $$ amnt corresponding to code fills
New York
San Diego
Los Angeles