Excel Question You could juggle around with these lines and adapt them to what you need... All the dollars are absolute references so that you can copy the formula from where you initially type it and it still works.
120 codes is too many for a pull-down selection. I'll assume your pricing table's on Sheet 2 and that it's:
Headers, A1="Type" A2="Description" A3="Price"
Data, A2:C121 contain the table data
So, for (say) row 8 in Sheet 1 that has (say) column F as the entered type, column G as the displayed description and column H as the displayed price,
G8 will test if anything's in F8 and if there is, it shows either "Invalid Type!" or the correct description
=IF(ISBLANK(F8),"",IF(ISNA(VLOOKUP(F8,$Sheet2!$A$2 :$C$121,2,FALSE)),"Invalid Type!",VLOOKUP(F8,$Sheet2!$A$2:$C$121,2,FALSE)))
H8 will test if anything's in F8 and if there is, it shows either nothing if F8's invalid or the correct price (which might or might not be zero)
=IF(ISBLANK(F8),"",IF(ISNA(VLOOKUP(F8,$Sheet2!$A$2 :$C$121,3,FALSE)),"",VLOOKUP(F8,$Sheet2!$A$2:$C$12 1,3,FALSE)))
__________________
My System: Tim CPU(s): Athlon 64 3500+ | Motherboard: Asus A8N-VM CSM | RAM: Corsair PC3200 CL2 DDR-400 2GB | Graphics Card(s): nVidia Geforce 6600 512MB | Sound Card: Cherry RS 6000 M keyboard | Hard Drive(s): Barracuda.7+ 2x200GB 58MB/s sustained | Optical Drive(s): Samsung DVD-ROM TS-H352 | Case / PSU: Thermaltake Soprano | Cooling: Stock | Network / Internet: Telewest 2x20Mb/sec | Monitor(s): SXGA flat panel | Operating System(s): Slackware (2.6.24.3) (Fluxbox) (bash) | Want your system info in your signature? |