Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup formula - please help!
Hi
Service Matrix - Days Vancouver 7 Calgary 5 Edmonton 6 Winnipeg 5 Data days Vancouver 8 Calgary 5 Edmonton 8 Winnipeg 7 I want to set a formula wich look at the number of days of the data and match it up with the service defined in the Matrix and determine if the service is "On Time" or "Delayed". I was trying to do with " If and lookup " without success. Could anyone help me please. Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP FORMULA | Excel Discussion (Misc queries) | |||
lookup formula | Excel Worksheet Functions | |||
Max Lookup formula | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
lookup formula help | Excel Worksheet Functions |