Is there a way to have Excel use a lookup function to return multiple rows based on a selection. For example vlookup will pull information based on a one record match. I would like for Excel to return multiple records (without using a pivottable, won't work for this).
(example)
Retailer Outlet 2004 Sales etc… etc…
1 Jim's Corner Store $500
1 Jim's Corner Market $1,500
1 Jim's Gas $250
2 Bob's Convenience $5,000
2 Bob's Conv #2 $8,521
3 Fast Fuel #1 $1,025
4 Quick Trip #1 $6,000
4 Quick Trip #2 $7,500
4 Quick Trip #3 $2,400
4 Quick Trip #4 $35,264
4 Quick Trip #5 $63,541
4 Quick Trip #6 $6,874
4 Quick Trip #7 $321
4 Quick Trip #8 $687
4 Quick Trip #9 $21,321
4 Quick Trip #10 $6,984
5 Fred's Amoco $542
Now can I have a lookup find all records for retailer 4 and have it show only those (Tried a filter function, won't work, I have a certain format that it needs to come down in) Any help would be appreciated
Thanks, Paul
(example)
Retailer Outlet 2004 Sales etc… etc…
1 Jim's Corner Store $500
1 Jim's Corner Market $1,500
1 Jim's Gas $250
2 Bob's Convenience $5,000
2 Bob's Conv #2 $8,521
3 Fast Fuel #1 $1,025
4 Quick Trip #1 $6,000
4 Quick Trip #2 $7,500
4 Quick Trip #3 $2,400
4 Quick Trip #4 $35,264
4 Quick Trip #5 $63,541
4 Quick Trip #6 $6,874
4 Quick Trip #7 $321
4 Quick Trip #8 $687
4 Quick Trip #9 $21,321
4 Quick Trip #10 $6,984
5 Fred's Amoco $542
Now can I have a lookup find all records for retailer 4 and have it show only those (Tried a filter function, won't work, I have a certain format that it needs to come down in) Any help would be appreciated
Thanks, Paul