Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP, INDEX, MATCH... What to choose
Hi everybody.
Here is table on sheet1 A B C D E F G 1Order Nr Cust PO Cust Name Order Date Post Code Volume Price/Liter 2 SY 12000 ? 3 DE 6000 ? 4 WW 40000 ? 5 FM 20000 ? 6 M 35000 ? Here is table on sheet 2: A B C D E 1 Postcode 0-1000 1001-2000 2001-3000 3001-4000 2 SY 1 2 3 4 3 DE 8 9 10 11 4 WW 15 16 17 18 What formula should I use to have sheet1:G populated automatically. The choice is made depending on the Pose Code and the Volume. Many thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup or Index Match ? | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Vlookup, index, match? | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |