INDEX Multiple matches

Originally Posted by deftones200

Hi,

This seems complicated to me so i'll try to explain it best i can! I have a worksheet called "Search" and one called "Relamps". Relamp sheet contains store no, name, then types of lamps and quantities.

In the "Search" worksheet, the user will enter a store number in cell A7 and effectively i want to mimic the data in the relamp section. Averagely, for one store there are about 45 rows.

I tried using and INDEXMATCH forumla, and VLOOKUP but i cant get it to return multiple results going downward, if you see what i mean.

Relamps sheet looks like this :-

A B C D E
1 London June CDMT 50W

Any help, much appreciated

Tim

See attached file.