Hello, I am trying to use INDEX / MATCH to search a value based on multiple criteria across rows and columns (I'm using Excel 365 but compatibility with earlier versions would be nice). The raw data tab contains the raw data and the match tab contains the desired output. I tried the following but get only #N/A and can't figure out why!
=INDEX(raw!D2:E11;MATCH(1; (match!A7=raw!A2:A11) * (match!B7=raw!B2:B11) * (match!C6=raw!C2:C11) * (match!A3=raw!D1:E1);0))
Bookmarks