One possible way

=INDEX(Price_Range,MATCH(1,(Part_Number_Range=look up1)*(Price_Band_Range=loo
kup2),0))

entered with ctrl + shift & enter


--

Regards,

Peo Sjoblom


"Monkey" wrote in message
...
I am attempting to create a simple quotation sheet

I have one cell in Sheet1 validated as list:
C1 - Customer Price-band Category (select from list)

and cells each refering to:
A1:A100 - Part Numbers (select from list)

In Sheet2, I have price lists for each Price-band Category against each
Part
Number.

In the cell adjacent to the Part Number in Sheet1, I would like to display
the relevant part price depending on which Price-band Category and which
Part
Number has been selected

I would appreciate any thoughts...