VLOOKUP from multiple cells in mulitple tables

  • Thread starter Thread starter Michael Brothers
  • Start date Start date
M

Michael Brothers

I am using vlookup to secure data in three different cells
from three separate tables. This works great. I now need
to take that information and aquire a code from a table
that includes all of the possible results for cells
1,2,and 3.
Example: cell B1=L6, B2=C, and B3=6
My table looks like this:
L6 B 6 SA
L6 B 7 SB
L6 B 8 SC
L6 C 6 SD
L6 C 7 SE
L6 C 7 SF
L7 B 6 SG
L7 B 7 SH
The result I am looking for is SD.

I tried =VLOOKUP(B1:B3,H1:K8,4), I guess you can tell, It
didn't work. Any help would be appreciated. Thanks a lot!
 
Mike,

Try the following array formula.

=INDEX(H1:H8,MATCH(B1&B2&B3,E1:E8&F1:F8&G1:G8,0))

Enter with Ctrl+Shift+Enter and it will appear in {}'s

:I've assumed your table is in E1:H8. Adjust your ranges as needed.

PC
 
Let B2:E9 house the sample table in Sheet1.

In A2 enter & copy down:

=B2&CHAR(127)&C2&CHAR(127)&D2

In B4 in the destination sheet enter:

=VLOOKUP(B1&CHAR(127)&B2&CHAR(127)&B3,Sheet1!$A$2:$E$9,5,0)

where B1 houses a value like "L6", B2 "C", and B3 6.
 
Aladin,

Can you please tell me what CHAR(127) is? I get an empty square indicating
a non-printing character.

Thank You

Sandy
 
Back
Top