A Question about LOOKUP

rowie

New Member
Joined
Oct 1, 2014
Messages
31

Sheet1 always stays the same and Sheet2 always changes.
I would like to pull info from Sheet2.
Example: C9-I9, from Sheet1, should look up for 006, in A2-A6 of Sheet2, it should grab the info from C2-I2 and place it into C9-I9.

Is this possible?
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

jduley

Board Regular
Joined
May 8, 2014
Messages
64
You could use a different vlookup in each of the columns, see below.

C2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,3,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,3,FALSE))
D2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,4,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,4,FALSE))
E2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,5,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,5,FALSE))
F2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,6,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,6,FALSE))
G2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,7,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,7,FALSE))
H2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,8,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,8,FALSE))
I2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,9,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,9,FALSE))
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
I would do

Sheet1 C2 filled right/down to I23

=INDEX(Sheet2!C$2:C$8,MATCH($A2,Sheet2!$A$2:$A$8,0))
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top