Cell A1-items I want to lookup
Part Number
ColumnA - from different sheet
abc1
abc2
abc3
Lookup Table - different sheet
ColumnA ColumnB
abc1 machine1
abc1 machine2
abc2 machine1
abc2 machine2
abc2 machine3
abc3 machine1
abc3 machine2
I want to vlookup abc1 with the lookup table and get both the machine1 and machine2 for the output.
Possible?
Hi Choke,
Welcome to the forum.
You can use the below formula to obtain multiple look-ups :-
{=INDEX($I$1:$J$8,SMALL(IF($I$2:$I$8=$A$1,ROW($I$2:$I$8),""),ROW($A1)),2)}
Multiple lookup (vlookup).xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks