A Question about LOOKUP

[rowie]

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?

 

[jduley]

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]

I would do

Sheet1 C2 filled right/down to I23

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

 

[rowie]

Cheers for that, helped me out a lot.

 

[Jonmo1]

You're welcome.