I need to match on three fields and get the quanity from the match.
I have 1. Routes
2. Pole/House
3. Unit
4. Quanity
The Spec (green) says what should have been placed at the house.
Placed is what was actually installed. (yellow)
I need to match the spec with the placed and determine the difference.
Some placed units will not match the spec because it required addtional units.
See attached
Lookup Using Multiple Criteria & Return Cell To Right
-
-
-
Re: Find a Match using multiple criteria and get data.
Concatenate your 3 criteria column cells and use VLOOKUP or INDEX/MATCH
-
Re: Lookup Using Multiple Criteria & Return Cell To Right
For Spec
N3=SUMPRODUCT(--(A$3:A$11=K3),--(B$3:B$11=L3),--(C$3:C$11=M3),(D$3:D$11))
For Placed
O3=SUMPRODUCT(--(F$3:F$11=K3),--(G$3:G$11=L3),--(H$3:H$11=M3),(I$3:I$11))
Copy and drag down -
Re: Lookup Using Multiple Criteria & Return Cell To Right
Great! I need to search to see if the placed units are on the spec list and place the spec qty in column (V).
I will then do a filter to find those units which I need additional information on.
Thanks
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!