I need some assistance on creating a "double lookup." Essentially what I am
trying to do is the following:
Object: retrieve a number from multiple lists determined by company name and
date.
Source data would include a company name i.e. company A, B, or C and also
the date an order was placed. Those two criteria would need to be used in
order to determine the retrieved number.
For example, if the order is for company B on 08/28/08. I would need to
create a lookup that retrieves a number from list B for that date or later.
Any help would be much appreciated. Thank you.