Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |