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

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

Hi again,

I just read you question again and realized that I provided the delay in
days when you wanted Delayed or On time. Modify the formula to this if that
is what you want:-

=IF(B2-VLOOKUP(A2,$E$2:$F$5,2,FALSE)<0,"Delayed","On Time")

The formula assumes that if the Data days is larger than the matrix days
then it is delayed and that if data days is the same or less than matrix days
then it is on time.
--
Regards,

OssieMac


"OssieMac" wrote:

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

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

MSISDN REMARKS MSISDN
9852356595 9852356595
9852356667 9852356667
9852446813 9852446813
9852459761 9852459761
9852459812 9852459812
9852459833 9852459833
9852459835 9852459835
9852459852 9852459852
9852459857 9852459857
9852459859 9852459859
9852506245 9852506245
9852506289 9852506289
9852506292 9852506290
9852506294 9852506294
9852506296 9852506296
9852514212 9852514212
9852514218 9852514218
9852514224 9852514224
9852514237 9852514237
9852514240 9852514240
9852514241 9852514241
9852514250 9852514250
9852514268 9852514268
9852514292 9852514292
9852514299 9852514299
9852514304 9852514304
9852514345 9852514345
9852514346 9852514344
9852514347 9852514347
9852514352 9852514352
9852514354 9852514354
9852514355 9852514355
9852514357 9852514357
9852514358 9852514358
9852514359 9852514359
9852514387 9852514387
9852514388 9852514388
9852514389 9852514389
9852514403 9852514403
9852514407 9852514407
9852514431 9852514431
9852514434 9852514434
9852514457 9852514457
9852514458 9852514458
9852514462 9852514462
9852514482 9852514482
9852514489 9852514489
9852514494 9852514494
9852514496 9852514496
9852514498 9852514498
9852514500 9852514500
9852514523 9852514523
9852514524 9852514524
9852514529 9852514529
9852514578 9852514578
9852514579 9852514579
9852514581 9852514581
9852514587 9852514587
9852514592 9852514592
9852514597 9852514597
9852514598 9852514598
9852514599 9852514599
9852576901 9852576901
9852576903 9852576903
9852576906 9852576906
9852576907 9852576907
9852576915 9852576915
9852576916 9852576916
9852576920 9852576920
9852576921 9852576921
9852576930 9852576930
9852576931 9852576931
9852576934 9852576934
9852576935 9852576935
9852576948 9852576948
9852576949 9852576949
9852576950 9852576950
9852576955 9852576955
9852576956 9852576956
9852576958 9852576958
9852576959 9852576959
9852576965 9852576965
9852576966 9852576966
9852576970 9852576970
9852576972 9852576972
9852576974 9852576974
9852576975 9852576975
9852576984 9852576984
9852576985 9852576985
9852576991 9852576991
9852576992 9852576992
9852577011 9852577011
9852577012 9852577012
9852577021 9852577021
9852577075 9852577075
9852577077 9852577077
9852577078 9852577078
9852577081 9852577081
9852577095 9852577095
9852577100 9852577100
9852577131 9852577131
9852577132 9852577132
9852577133 9852577133
9852577140 9852577140
9852577146 9852577146
9852577147 9852577147
9852577148 9852577148
9852577149 9852577149
9852577151 9852577151
9852577162 9852577162
9852579108 9852579108
9852584712 9852584712
9852584748 9852584748
9852584826 9852584826
9852584841 9852584841
9852584874 9852584874

Dear Sir,

Here i am sending some mobile no, i just wanted coloum a = coloum b by
vlookup formula.
i want to vlookup formula on this catagray, please send the formula

wrote in message
...
MSISDN REMARKS MSISDN
9852356595 9852356595
9852356667 9852356667
9852446813 9852446813
9852459761 9852459761
9852459812 9852459812
9852459833 9852459833
9852459835 9852459835
9852459852 9852459852
9852459857 9852459857
9852459859 9852459859
9852506245 9852506245
9852506289 9852506289
9852506292 9852506290
9852506294 9852506294
9852506296 9852506296
9852514212 9852514212
9852514218 9852514218
9852514224 9852514224
9852514237 9852514237
9852514240 9852514240
9852514241 9852514241
9852514250 9852514250
9852514268 9852514268
9852514292 9852514292
9852514299 9852514299
9852514304 9852514304
9852514345 9852514345
9852514346 9852514344
9852514347 9852514347
9852514352 9852514352
9852514354 9852514354
9852514355 9852514355
9852514357 9852514357
9852514358 9852514358
9852514359 9852514359
9852514387 9852514387
9852514388 9852514388
9852514389 9852514389
9852514403 9852514403
9852514407 9852514407
9852514431 9852514431
9852514434 9852514434
9852514457 9852514457
9852514458 9852514458
9852514462 9852514462
9852514482 9852514482
9852514489 9852514489
9852514494 9852514494
9852514496 9852514496
9852514498 9852514498
9852514500 9852514500
9852514523 9852514523
9852514524 9852514524
9852514529 9852514529
9852514578 9852514578
9852514579 9852514579
9852514581 9852514581
9852514587 9852514587
9852514592 9852514592
9852514597 9852514597
9852514598 9852514598
9852514599 9852514599
9852576901 9852576901
9852576903 9852576903
9852576906 9852576906
9852576907 9852576907
9852576915 9852576915
9852576916 9852576916
9852576920 9852576920
9852576921 9852576921
9852576930 9852576930
9852576931 9852576931
9852576934 9852576934
9852576935 9852576935
9852576948 9852576948
9852576949 9852576949
9852576950 9852576950
9852576955 9852576955
9852576956 9852576956
9852576958 9852576958
9852576959 9852576959
9852576965 9852576965
9852576966 9852576966
9852576970 9852576970
9852576972 9852576972
9852576974 9852576974
9852576975 9852576975
9852576984 9852576984
9852576985 9852576985
9852576991 9852576991
9852576992 9852576992
9852577011 9852577011
9852577012 9852577012
9852577021 9852577021
9852577075 9852577075
9852577077 9852577077
9852577078 9852577078
9852577081 9852577081
9852577095 9852577095
9852577100 9852577100
9852577131 9852577131
9852577132 9852577132
9852577133 9852577133
9852577140 9852577140
9852577146 9852577146
9852577147 9852577147
9852577148 9852577148
9852577149 9852577149
9852577151 9852577151
9852577162 9852577162
9852579108 9852579108
9852584712 9852584712
9852584748 9852584748
9852584826 9852584826
9852584841 9852584841
9852584874 9852584874

Dear Sir,

Here i am sending some mobile no, i just wanted coloum a = coloum b by
vlookup formula.
i want to vlookup formula on this catagray, please send the formula

Sorry, but it's not clear what you want. If you just want to see if
columnA=columnB for each line, put this formula in C1 and copy it down as
far as needed:
=(A1=B1)