Index / Match Hi, I\'m having problems using this function and NOt getting the d
ID: 643027 • Letter: I
Question
Index / Match
Hi, I'm having problems using this function and NOt getting the dreaded #N/A retruned.
Here we go....
On sheet1 I have drop downs in Cells A11, B11 & C11 based on lists.
On sheet2 I have Data in Columns A,B,C & D.
The drop downs in A11 equate to Column A, B11 to B and C11 to C.
Column D has different values dependant on the combination of data in A-C.
what I want is for Cell D11 on Sheet1 to show a value from Column D in Sheet 2 depending on the values entered in A11-C11.
Can anybody help with the correct syntax???
Thanks !!
Explanation / Answer
Hi..
Try this, it will return a blank cell if there's no matches:
=IFERROR(LOOKUP(2,1/((Sheet2!A2:A1000=A11)*(Sheet2!B2:B1000=B11)*(Sheet2!C2:C1000=C11)), Sheet2!D2:D1000),"");