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
|