Need help with Index Match function

[teejayj]

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

 

[AhoyNC]

Try this.
Click on cell that has your formula.
press F2 for edit mode
Then press CTRL-SHIFT-ENTER and you should see the braces.

Also I tried your formula and it worked for me.

 

[RatExcel]

Try:

=INDEX(D$1900:F$5066,MATCH(D43&H43,D$1900:D$5066&H$1900:H$5066,0))

Use CTRL+SHIFT+ENTER