Thread: Vlookup and IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jpsabourin@quickbusiness.com is offline
external usenet poster
 
Posts: 15
Default Vlookup and IF

I am unable to figure out the formula for and IF factor in Vlookup.

Example I have three delivery service, Good, Faster, Fastest. each
has a time alloted to them.

Faster is delivered in 2 hours and Fastest is delivered in 1 hour.
The problem is Good. How do I get a formula so that when Good is
entered in the delivery type cell, it will choose the the formula
according to the activated time.

i.e. If p/u at 8:am we have until 5pm to deliver, but if the call is
entered after 11:59am we have until 12noon the next day to deliver. I
cannot use different names, it needs to choose the appropriate
formula.

Thanks for your help
JP