Forum Discussion
Index & Match formula not working on multiple column
Hi Folks,
I'm facing error on the match formula, which I tried to apply, I'm getting #N/A error... I tried few trouble shoots to make it work (adding helper column, broke the formula with "&" to make it work, checking for any additional characters & checking the format etc) but it is not working.
I have used Match formula earlier, but never had this issue. I want a single formula to MATCH & verify multiple column to return the desired output, I can do single column verification & again to do the next column verification and get the result but it is tedious and not time saving. Kindly help me to learn how to make a formula work to one validation of multiple column.
Kindly attaching the sheet for reference
=INDEX($C$2:$C$15,MATCH(1,($A$2:$A$15=E3)*($B$2:$B$15=F3),0))This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
Here's an advanced example for INDEX and MATCH with multiple columns and approximate match:
INDEX and MATCH approximate match with multiple criteria - Excel formula | Exceljet
