<or = Courier N W E S
299 Surface 7 5 10 4
599 Surface 10 10 15 12
1000 Surface 15 15 30 16
299 Arrow 20 34 18 21
599 Arrow 30 44 28 35
1000 Arrow 46 54 38 46
This master Table sheet1
Courier side Weight Rate
Surface E 100
Surface W 1000
Arrow S 26533
Surface N 23231
Arrow E 255
Surface E 455
Arrow W 121
Arrow N 1500
Surface S 45
Arrow W 46
Arrow E 458
Surface S 753
Arrow W 12
Arrow N 2554
Surface W 1213
Arrow W 456
Surface S 78
Sheet 2
i want fetch the data in Rate column, if column courier and side matching in sheet1 and the weight is <= column1 of sheet1
Eg:
Courier side Weight Rate
Surface E 100 10
Surface W 1000 15
Bookmarks