Hi !!1 good Evening .

Let me Give a breif...exmple

Sheet 1

Org Dest TAT
BBI CCU
CTK BBI
BKS BBI
BHG CTK

Col A contain : Origin City code
Col B contain : Destination Code

Col C TAT to be calculate(?)


Sheet 2 MATRIX (134 cols and 134 rows)

Stn CCU BBI BHG BKS BLS CTK
CCU 1 1 1 1 1 1
BBI 1 1 2 2 2 2
BHG 1 2 1 2 2 2
BKS 1 2 2 1 2 2
BLS 1 2 2 2 1 2
CTK 1 2 2 2 2 1
GAU 1 2 2 2 2 2
IMF 1 2 2 2 2 2

Sheet 2 is matrix contain the time in Days if any shipment travel between any two city. we can assume origin or destination to any of the axis as its a Square matrix containing same codes in x and y axis.

Now have to check for TAT in Sheet 1. (COL C )
i m trying to pu Vlookup and Match but is not working ....