Ok. I decided to drop the codes and just use a validation list of the items. I have a crazy 200 character long series of IF statements that seems to work with the 1,0.75, 0.5, and 0.25 sizes. In there it is declared if greater than 1 to times by the quantity and cost from the 1 column. It's probably the long way around. But with the help of that VLOOKUP function, I was able to conquer it. Thanks for all the help. I now understand the validation tool which is great because i want to have 5 or so sheets of data, and then one clean sheet styled in a printable quote format with info pulled from everywhere. If someone wants to look at the crazy formula that worked I will post the sample sheet.

sample changedj.xlsx