VLOOKUP statements

[Guest]

I have a worksheet with two different tabs. The one has an order date and a
delevery date. The other has the item and how long it is suppose to take to
be delievered. I need to find out whether the delievery date is either under
the time allowed or over the time allowed and for it to come up as true for
if it is before the date and false if its after the date.
thanks

 

[Guest]

Hi, Jennifer Kramer;
If I understand you right...,
On sheet1
=IF(B2-A2<=VLOOKUP(C2,Sheet2!A2:B10,2,FALSE),TRUE,FALSE)
Where on Sheet1
A2=order date
B2=delivery date
C2=item name
And on Sheet2
A2:B10 is the range of your lookup table
column A: names of items
column B: number of days allowed for delivery
Regards,
IanRoy.