I need to update pricing based on different scenarios for different product
groups. I have one spreadsheet that has each item, its product group and 3
levels of current pricing . I have another that lists each product group and
the factors for the new pricing. Im trying to use VLOOKUP to use the
Product Group to update the pricing based on the corresponding factor, but I
cant seem to find a way to use these factors - as they are treated as text.

I have 31,000 items and 21 product groups.

EXAMPLE:

ITEM NewPrice1 NewPrice2 NewPrice3 Price1 Price2 Price3 Product Grp
ABC ? ? ? 5.00 3.00
3.00 1001
AB5 7.00 7.00
6.50 1021


PRODUCT GROUP NewPrice1 NewPrice2 NewPrice3
1001 Price2*.85 Price2*1.00 Price2*1.00
1002 Price3*.95 Price3*.85 Price2*1.00