Index / Match Hi, I’m having problems using this function and NOt getting the dreaded #N/A retruned.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Order a Similar Paper HERE Order a Different Paper HERE

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