Posted to microsoft.public.excel.worksheet.functions
|
|
Vlookup Multiple Matches
Hi,
You can also refer to my article at -
http://office.microsoft.com/en-us/ex...260381033.aspx
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"RoadKill" wrote in message
...
Okay, here is my current formula: =VLOOKUP(B$3, Sups!$A2:$D$1000,2,0)
The problem is that B3 may appear up to 20 times and vlookup only pulls
the
first match. But I want it to pull every instance when I drag the fomula
down. To elaborate, B5 of the current sheet would display the first
instance,
B6 the second and on down the line.
I seem to remember doing it before but cannnot recall whether is was using
match, etc.
Thanks for your help.
|