Assuming that your data is laid out as per the following:-

Service Matrix Days Difference Data days
Vancouver 7 -1 Vancouver 8
Calgary 5 0 Calgary 5
Edmonton 6 -2 Edmonton 8
Winnipeg 5 -2 Winnipeg 7

Service matrix data (without column header) is in range A2:B5

Data (without column header) is in range E2:E5


Formula in cell C2 (Under Difference):-

=B2-VLOOKUP(A2,$E$2:$F$5,2,FALSE)

Copy the formula down. Result is Number (Positive, Negative or Zero).

Note that the lookup range in the formula is absolute with the $ signs.

--
Regards,

OssieMac


"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