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 above for reference. Highlighted the error in yellow hue(Sheet name - result).
m_tarler & HansVogelaar - Please help, Thanks in advance
The link doesn't work - it requires a login.
