Hi,

I am building a spreadsheet to display a quotation for customers. I have created two drop down lists that contain the width and height of kitchen doors. I want to use the IF function to look at the two selected sizes within each drop down list to generate a price from a table on sheet two.

Firstly, is the IF function the right thing to be using? I can get this to work fine with one drop down list but I can't work out how to get it to check the contents of two cells to then generate a result.

The function I have written is:

=IF(A2=115&B2>160,'Kitchen Prices'!E4,0)

Thanks

D