Home » Forums » Open Source Learning Center » Question and Answer

INDEX / MATCH Table Values

Submitted by SalientAnimal on 24 March, 2014 - 09:21

Hi All,

I have a workbook with two sheets. Sheet 1 in my reference sheet (sheet with my table) and sheet 2 is my actual data_sheet. On my data_sheet I have a set of data similar to the file on dropbox

https://www.dropbox.com/s/tzsu9iegznbs9vb/INDEXMATCH_Smaple.xlsx

‹ help needed on sorting data based on multiple colums Getting names for corresponding numbers ›
»
Vikas Verma's picture

Please Explain more

Submitted by Vikas Verma on 24 March, 2014 - 10:51.

Hi Please explain more about your query and required output.

Thanks

»

I need to lookup to my

Submitted by SalientAnimal on 24 March, 2014 - 10:58.

I need to lookup to my "table" on my filters sheet and return the heading from the column in which a match is found. I have got this formula that currently works [=IFERROR(INDEX(Filters!J$1:AB$1,MATCH(C3,Filters!J$2:AB$2,0)),IFERROR(INDEX(Filters!J$1:AB$1,MATCH(C3,Filters!J$3:AB$3,0)),IFERROR(INDEX(Filters!J$1:AB$1,MATCH(C3,Filters!J$4:AB$4,0)),IFERROR(INDEX(Filters!J$1:AB$1,MATCH(C3,Filters!J$5:AB$5,0)),"Not Found"))))], however for every row in my table, I need to add another line to the formula.

»
Vikas Verma's picture

Solution--Try this

Submitted by Vikas Verma on 24 March, 2014 - 14:36.

Hi Dear,

Hope you are looking for this...

=INDEX(Filters!$J$1:$AB$4,1,MAX(((B3=Filters!$J$2:$AB$4)*COLUMN(Filters!$A$1:$S$1))))

https://drive.google.com/file/d/0B31mi9BnCLpMVHNZSXd4LTRvN3c/edit?usp=sh...

use above mentioned with CSE.

Thanks

»