Quote:
Originally Posted by Mazzaropi
Dear Pamanabh, Good Afternoon.
Could you show us a little example about your desired results to easier our help to you?
Remember that you know a lot about your data and how they work together, and for us itīs the first time that we see them, isnīt?
|
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 ....