View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
orquidea orquidea is offline
external usenet poster
 
Posts: 132
Default Lookup formula - please help!

Thanks a lot, It worked.

Orquidea

"orquidea" wrote:

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