I want to know how to do a VLookUp (I think that is the formula, I would you
use) with multiple criteria. For example:

If the supplier is George O'Days and the lot # is 10100, then I would want
the corresponding new and recon. value's inserted in the appropriate columns.

If and If Then 1 Then 2
Supplier Lot # Value New Value ReCon.
George Oday 10100 $149.00 $91.25


-Thank you, Kimberly