VLOOKUP statements
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 |
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. "Jennifer Kramer" wrote: 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 |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com