MrExcel Publishing
Your One Stop for Excel Tips & Solutions

VLOOKUP Problem!!

Posted by Gary on July 23, 2001 12:01 PM

how do I Lookup values from a list where there are more than one of the given value in the first column? For example, if I want to Lookup 5 shortstops in a certain position and the first column is the position. I want to do this in consecutive cells down a page. example

shortstop player #1
shortstop player #2
pitcher player #1
1st Baseman player #1
shortstop player #3

Posted by lenze on July 23, 2001 2:01 PM

Gary: Why not use a Pivot table instead. you can make the position field a Page item.