Forum Discussion

Copper Contributor

Mar 09, 2025

Solved

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

BI & Data Analysis

excel

Formulas and Functions

OliverScheurich
Mar 14, 2025
=IFNA(INDEX('RAW - reference '!$A$2:$A$72,MATCH(TRUE,(('RAW - reference '!$B$2:$B$72=Result!A2)+('RAW - reference '!$D$2:$D$72=Result!A2))>0,0)),"")
You are welcome. Please share your expected result with your sample file. Does this formula return the intended output?
Index and Match formula not working on multiple columns.xlsx15 KB

Pravcha19

Copper Contributor

Mar 14, 2025

OliverScheurich - Thanks for the update, sure will ensure for not adding sensitive information.

The formula is not giving output for all the line items, even in the attached solve sheet, the formula is selectively giving the output, the same happens when I tried to replicate the formula in another sheet.. Why it is not giving output for all the line items...? Please redress..

OliverScheurich

Gold Contributor

Mar 14, 2025

=IFNA(INDEX('RAW - reference '!$A$2:$A$72,MATCH(TRUE,(('RAW - reference '!$B$2:$B$72=Result!A2)+('RAW - reference '!$D$2:$D$72=Result!A2))>0,0)),"")

You are welcome. Please share your expected result with your sample file. Does this formula return the intended output?

Index and Match formula not working on multiple columns.xlsx15 KB

Pravcha19
Copper Contributor
Mar 15, 2025
Thanks Indeed its working!
Pravcha19
Copper Contributor
Mar 15, 2025
OliverScheurich - Thanks for the updated formula, but when I replicate the formula in the excel getting the below error.