I am trying to do multiple lookups. The following data is what I am working with:
Plant Position Shift Material Quantity
CA1A ISP1 1 4001 6,163
CA1A ISP1 2 4055 1,914
CA1A AI 3 4001 3,112
CA1B REP1 1 4003 2,950
CA1B ISP1 2 4001 2,803
CA1B AI 3 4001 867
CA1C REP1 1 4003 5,436
CA1C REP1 2 4003 3,175
CA1C REP1 3 4055 3,892
CA1D ISP1 1 4055 2,843
CA1D AI 2 4003 2,509
CA1D AI 3 4002 2,632
CA1E ISP1 1 4002 2,816
CA1E REP1 2 4004 2,300
CA1F AI 1 4055 2,192
CA1G AI 1 5001 4,222
What I would like is to lookup a specific plant, position, shift and material and get back the quantity.
I don't know if it is easiest to use multiple vlookups or if statements.
Any help would be great.
Thanks.
Plant Position Shift Material Quantity
CA1A ISP1 1 4001 6,163
CA1A ISP1 2 4055 1,914
CA1A AI 3 4001 3,112
CA1B REP1 1 4003 2,950
CA1B ISP1 2 4001 2,803
CA1B AI 3 4001 867
CA1C REP1 1 4003 5,436
CA1C REP1 2 4003 3,175
CA1C REP1 3 4055 3,892
CA1D ISP1 1 4055 2,843
CA1D AI 2 4003 2,509
CA1D AI 3 4002 2,632
CA1E ISP1 1 4002 2,816
CA1E REP1 2 4004 2,300
CA1F AI 1 4055 2,192
CA1G AI 1 5001 4,222
What I would like is to lookup a specific plant, position, shift and material and get back the quantity.
I don't know if it is easiest to use multiple vlookups or if statements.
Any help would be great.
Thanks.