**Added Excel Attachment



I have been trying to figure out what I am doing wrong with the INDEX function.

What is my goal? Look at a cell, look through the table array in column A and give all the results for multiple columns for anything that matches in column A. I got it to work for 1 column, but when I try to display the second, third, forth column results, it does not work. Below is my image of my sheet

Image:

https://imgur.com/xbElptr


My J2 through J16 has the INDEX command working fine. It is pulling from column B. Now column K I want now pull the value from the next column to the right. On the first results, great it found Arrowbear Lake in column B, but in column K I want to find the same search (J1) but pull from column C. On this example it would pull the value "county".

What do I need to change to make this work. Here is my index value in K2 and I always use CTRL > Shift > Enter.

=IF(ISERROR(INDEX($A$1:$H$16,SMALL(IF($A$1:$A$16=$ J$1,ROW($A$1:$A$16)),ROW(1:1)),2)),"",INDEX($A$1:$ H$16,SMALL(IF($A$1:$A$16=$J$1,ROW($A$1:$A$16)),ROW (1:1)),2))


Any help would be great.

Jeff Unruh

Attached Files

index test.xlsx (10.0 KB, 28 views)