Forum Discussion
Indexing Mult. Unique Cells by Matching Cell of Table1 to Mult. Cells of Table2 - Create Dropdown
I have two tables. One is a list of primary keys I want to return data for. The other table is a list of duplicate primary keys with unique cells. I want to match primary keys and have a drop down of...
Ctrl+Shift+Enter
=IFERROR(INDEX(Sheet1!$B$1:$B$20,SMALL(IF(Sheet1!$A$1:$A$20='2019 ZIP Codes and Cities'!$A$2,ROW(Sheet1!$A$1:$A$20)),ROW(A1)),1),"")
Pull vertically as far as needed. Error check included so you won't get #NUM errors when there's no more cities to pull.
If you have FILTER function that's an option, too.