Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
column matching | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching data from column b | Excel Worksheet Functions | |||
matching the column b(sku)c(count)with A | Excel Worksheet Functions |