Forum Discussion
Index & Match formula not working on multiple column
=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?
OliverScheurich - Thanks for the update... but I use office 365... I'm not using the formula on web excel.
Kindly attaching the sheet, please apply the formula in the data sheet highlighted with yellow hue
INDEX and MATCH works in Office 365 and Excel for the web and in legacy Excel versions such as Excel 2013. Thanks for sharing a sample file and please don't publish content with sensitive data such as names of real people. Do the formulas in the attached sample file return the intended result?
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..=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?
Thanks Indeed its working!