ChazGarrett
New Member
- Joined
- Jun 8, 2015
- Messages
- 2
I have a very large spreadsheet (10k+ items). I need to do an index that returns multiple results. The formula I use (below) works on other pages in this WB but on one I keep getting a #NUM! error. I have no unusual characters or blank spaces in the search array or the results array. I will send a link of the file to anyone that wants to take a look at it.
My Formula:
Col A = Search Array - (City Names)
Col B = Results Array - (Census Tract Numbers ie 48001950100)
C1 = Search Criteria - (City Name)
C3 = Search Results - (Corresponding CT numbers)
{=INDEX($A$2:$B$9250,SMALL(IF($A$2:$A$9250=$C$1,ROW($A$2:$A$9250)-1),COLUMNS($C3:C3)),2)}
My Formula:
Col A = Search Array - (City Names)
Col B = Results Array - (Census Tract Numbers ie 48001950100)
C1 = Search Criteria - (City Name)
C3 = Search Results - (Corresponding CT numbers)
{=INDEX($A$2:$B$9250,SMALL(IF($A$2:$A$9250=$C$1,ROW($A$2:$A$9250)-1),COLUMNS($C3:C3)),2)}