Hi Ellen,

In order to retrieve date based values you should first of all set up a
single field that will act as your "index code" in order for Vlookup to work.
Something like
040110120060217, consisting of your product code concatenated with an ANSI
date (YYYYMMDD). Then sort your pricelist data on your index key. That way
you can test when either your code or your date changes.

I have found it useful to set the latest (current?) value with a 20991231
date, which can never be less than what you search for.

HTH