Matching down a column
Hi all and thanks ahead of time for all help and suggestions provided.
Typically I would search for the answer but unfortunately time is not
on my side.
Here's part of my sheet1 set up.
D3:Q3 I have headers for my columns.
A2 has the name of a district that can be selected. (I used
data.validation to create a drop down)
Here's the results I'm after.
In cells B4:B15 I need to get the store numbers that match the
district in A2 by referencing sheet2. (sheet2 has a column with the
districts and their matching stores in the next column)
I tried to use "Index,Match" but the results are only the first store
that matches the district.
Again Thanks for any suggestions provided.
also if I've missed some detail, sorry about that. Again I'm in a bit
of a rush, not at all by choice.
|