Heshey,
On the first sight this seems a typical job for a VLOOKUP. But I must admit I don't grasp the full requirements.
There's info in Excel's help function, if the function wizard isn't clear enough. Or see http://www.ozgrid.com/Excel/excel-vlookup-formula.htm (just the first google hit for excel vlookup, you'll find many more if you go and look for it).
Hope this helps.
Kees
is there any way to code
ie 1=B 2=X 3=P etc
in a price list where the cell data is calculated

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic