# 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

#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.

Report •
Related Solutions