I have data array in A2 to AF 1843 and I wish to match additional data to it which is in data array A1900 to F5066. Typically I would use a vlookup. But I need to match at least two data elements to make a correct match.
Here is the function I wrote. I press the CTrl /Shift and Enter keys to get the braces. But the braces do not appear.
=INDEX(D$1900:F$5066,MATCH(1,(D$1900:D$5066=D43)*(H$1900:H$5066=H43),0),2).
I cannot determine why it is not working .
Any assistance is appreciated.
I've tried attaching a screenprint to not avail. So here is a link to the JPG.
https://drive.google.com/file/d/0B3FqMThxGdtaN2tHencyNkFEemM/edit?usp=sharing
Here is the function I wrote. I press the CTrl /Shift and Enter keys to get the braces. But the braces do not appear.
=INDEX(D$1900:F$5066,MATCH(1,(D$1900:D$5066=D43)*(H$1900:H$5066=H43),0),2).
I cannot determine why it is not working .
Any assistance is appreciated.
I've tried attaching a screenprint to not avail. So here is a link to the JPG.
https://drive.google.com/file/d/0B3FqMThxGdtaN2tHencyNkFEemM/edit?usp=sharing