J
jgabraham
I have a pricing worksheet in XL2003 that uses VLOOKUP to find the cost of
varied items. Ihave all these items in a separate worksheet (called CODES).
It is sorted in asceneding order. Some of the item prices use the VLOOKUP
function to reference the vendor's price list (which is also sorted in
ascending order). The problem imhaving is that the vendor's worksheet has
been update twice this year and sometimes the function in the pricing
worksheet returns the oldest price.
Any suggestions?
varied items. Ihave all these items in a separate worksheet (called CODES).
It is sorted in asceneding order. Some of the item prices use the VLOOKUP
function to reference the vendor's price list (which is also sorted in
ascending order). The problem imhaving is that the vendor's worksheet has
been update twice this year and sometimes the function in the pricing
worksheet returns the oldest price.
Any suggestions?