Forum Discussion
Solved
Index Match Match not returning expected results, referencing structured Table columns
Hi Everyone, I've been looking at this so long with no success and I think I just need a fresh set of eyes/another opinion so I would appreciate any input you may have. I'm using Office 365. ...
=IFERROR(INDEX(Revenue___Expense_GRNP_Trial[[amount]:[amount]],MATCH(1,($B10=Revenue___Expense_GRNP_Trial[[account description]:[account description]])*(D$5=Revenue___Expense_GRNP_Trial[[fund no.]:[fund no.]]),0)),"")You can try this formula which returns the expected result in my sheet.
=IFERROR(INDEX(Revenue___Expense_GRNP_Trial[amount],MATCH(1,($B10=Revenue___Expense_GRNP_Trial[account description])*(D$5=Revenue___Expense_GRNP_Trial[fund]),0)),"")This is shorter and works as well.
I've entered the formula in cell D10 and draged across range D10:I15. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=IFERROR(INDEX(Revenue___Expense_GRNP_Trial[[amount]:[amount]],MATCH(1,($B10=Revenue___Expense_GRNP_Trial[[account description]:[account description]])*(D$5=Revenue___Expense_GRNP_Trial[[fund no.]:[fund no.]]),0)),"")You can try this formula which returns the expected result in my sheet.
=IFERROR(INDEX(Revenue___Expense_GRNP_Trial[amount],MATCH(1,($B10=Revenue___Expense_GRNP_Trial[account description])*(D$5=Revenue___Expense_GRNP_Trial[fund]),0)),"")This is shorter and works as well.
I've entered the formula in cell D10 and draged across range D10:I15. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- That worked! Thank you!
