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???