Lookup on Multiple Criteria
Thanks for the quick response, I think you might be better able to assist if
you had some real data
A B C D E
GMPName LongName Area SOVID Name
GMP 1 Blue General Items 100 General Conditions
GMP 1 Green General Items 101 Clearing & Grubbing
GMP 1 Red General Items 102 Dust Control
GMP 1 Orange General Items 103 Mobilization
Knowing the GMPName, LongName, Area, and SOVID, I want to return the Name
field.
It is a unique value. I dont have much experience with Match & Index, but I
dont see how the proposed use of a 'Sumproduct' function would work?
Thanks
|