Multiple

hrad

New Member
Joined
Feb 1, 2005
Messages
23
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.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
There shouldn't ever be any multiple matches. By the time that each criteria has been met, there will be only one value.
I want the quantity returned if a certain criteria is met for Plant, Position, shift and material.
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top