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!