Multiple Criteria Lookup

[aprilannperry]

I have a table for which I'd like to return the following results:

Name 1, Criteria 1 and Criteria 2. Criteria 1 and 2 are located in the same column. I think this is throwing me off but the spreadsheet needs to be setup that way. The spreadsheet looks like this:

	Column 1	Column 2	Column 3	Column 4	Column 5
Row 1		Criteria 1	Criteria 1	Criteria 1	Criteria 1
Row 2	Name​	Criteria 2	Criteria 3	Criteria 4	Criteria 5
Row 3	Name 1
Row 4	Name 2
Row 5	Name 3

<tbody>
</tbody>

<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>

I have attempted to us an index/match formula with no luck. Any suggestions?

Thanks!

 

[Arithos]

To be clear, you want the spreadsheet example above, to be sorted so that the Name 1, and Criteria 1. Are listed in the same Column? (Not row) meaning you will have Name 1, Criteria 1, Criteria 1 etc. in one column?

 

[Canapone]

Hi All,

not sure to have undestood.

in A3 first name, in B3 to be copied across

=IFERROR(INDEX($B$1:$Z$2,COLUMN(A$1),COUNTA($A$3:$A3)),"")

<tbody>
</tbody>

in order to get

name 1 - criteria 1- criteria 2
name 2 - criteria 1- criteria 3
name 3 - criteria 1- criteria 4

and so on.

Hope it helps

 

[aprilannperry]

I was able to find my answer. Thank you.