Copy data to table by using two different index and match

Microsoft Excel 2010 - complete product...
October 4, 2016 at 01:28:08
Specs: Windows 64
Hi, I hope someone can help me with this.

Please refer this spreadsheet.

https://docs.google.com/spreadsheet...

In table 1, at functional role column (F7), there is list of functional role that I have to choose. At table 2 (AX6:DS25), I put this formula for cell AX9

=IFERROR(INDEX($C$203:$BX$231, MATCH($F9,$B$203:$B$231,0),1),"")

so that when I choose the respective functional role, it automatically copied data from table 3 to table 2.

My question is, how can I combine formula so that I can choose another list (Specific position column (G7), so that the data from table 4 can be copied to table 2, based on the specific position i choose.

Please note that the row header is the same for table 2, table 3 and table 4.


I hope u guys can understand my question.\

Thanks in advance.


See More: Copy data to table by using two different index and match

Reply ↓  Report •


#1
October 4, 2016 at 01:59:47
I tried to put this formula but I think its not correct.

=IFERROR(INDEX($C$203:$BX$257, MATCH($F9&$G9,$B$203:$B$231&$B$238:$B$257,0),1),"")

I put the IFERROR function only yo get rid of the N/A sign.


Reply ↓  Report •
Related Solutions


Ask Question