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

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!