Index match??

I have a main Data taband it will dsiplay the info by grabing it from another tab called Info.

There a four stores: A,B,C,D
Each store has a Item, price and size column.
Note: each store will have a differnt number of items

I want to on Data tab select the store from a drop down and then have all of its info displyed on the Data tab

I thought about using index match formula but i dont see how it will work for this case. any suggestions?

sample attached

Ramia, please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.

Dunc, please take a few minutes to read the forum rules about posting in threads with pending moderation.