R
RoadKill
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.
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.