assume the dropdown list box is done with data validation in cell B9 and you
want the price in C9. Further, assume you equipment list is in a sheet
named Data, with names corresponding to the dropdown in Column A and prices
in Column B.

In C9 put in a formula

=if(B9="","",Vlookup(B9,Data!A1:B500,2,False))

--
Regards,
Tom Ogilvy


"Dave" wrote in message
...
Hi. I'm hoping someone can give me some pointers on this.
I'm using Excel to produce a quote style system. I've got a drop-down list
to select different items of equipment. I have all the equipment items
with
their prices on the worksheet. I then need to construct a lookup table so
that when an item is selected from the list its price appears in the
column
next to it. I tried using IF functions but the list is pretty big and I
couldn't work out how to set totally separate IF commands for one cell.
These
prices are then totalled up, but I've got that sorted.

Any ideas? Many thanks people!