# Lookup between 2 sheets

#### leebauman

##### Board Regular
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!

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### Andrew Poulsom

##### MrExcel MVP
Try:

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

#### Jonmo1

##### MrExcel MVP
Try Index / Match

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

Hope this helps..

#### leebauman

##### Board Regular
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

##### MrExcel MVP
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

##### Board Regular
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

Replies
3
Views
40
Replies
0
Views
134
Replies
5
Views
32
Replies
6
Views
226
Replies
7
Views
85

1,191,704
Messages
5,988,181
Members
440,136
Latest member
dandanfielding

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back