CopperKnife
New Member
- Joined
- May 26, 2015
- Messages
- 14
Hello all,
I have two tables like the following.
Table-1
<tbody>
</tbody>
Table-2
<tbody>
</tbody>
I need to get the FreightKey from the second table to the first table.
I tried Index/Match with less than, greater than choices also Vlookup with approximate match. But I could not get the correct result.
I need to get the FreightKey according to their Weight and Mode of transport.
Please check the following link to get the sample work book.
https://drive.google.com/file/d/0B8-z_iZazKR1MFB1cDUxdkc4YkU/view?usp=sharing
Thanks
CopperKnife
I have two tables like the following.
Table-1
Weight | Mode | FreightKey |
10 | Road | ?????? |
8 | Rail | ?????? |
45 | Sea | ??????? |
5 | Air | ?????? |
23 | Sea | ?????? |
<tbody>
</tbody>
Table-2
Weight | Mode | FreightRate | FreightKey |
20 | Rail | 6% | RA20 |
30 | Road | 4% | RO40 |
40 | Air | 20% | AI40 |
50 | Sea | 8% | SE60 |
60 | Road | 12% | RO60 |
<tbody>
</tbody>
I need to get the FreightKey from the second table to the first table.
I tried Index/Match with less than, greater than choices also Vlookup with approximate match. But I could not get the correct result.
I need to get the FreightKey according to their Weight and Mode of transport.
Please check the following link to get the sample work book.
https://drive.google.com/file/d/0B8-z_iZazKR1MFB1cDUxdkc4YkU/view?usp=sharing
Thanks
CopperKnife
Last edited: