NDEX/MATCH, Multiple criteria

[AnenD]

I have data in columns A, B, and C in sheet1 and data in columns E, F, G, and H in sheet2. I have written an index/match formula in column D in sheet1 to match the data in columns A, B, and C with data in columns E, F, and G in sheet2 and return the data from column H in sheet2. I have checked to be sure that the formula is correct (=INDEX(Sheet2,MATCH(A2&B2&C2,E2&F2,G2,0),8); but the problem is that when a match is found, it returns the data from the row below the match.

Any ideas would be appreciated!!

 

[AnenD]

Oh well. At least it to worked the other way. Thanks so much for all the help!!

Don't know. If MATCH returns the right row number and if you count down that many rows in named_range and it gives the right answer the formula should work.

 

[AhoyNC]

You might open up Name Manager (CRL-F3 on a PC) where you can see how Excel has setup your named ranges and see if anything looks out of place.

 

[AnenD]

I am on a mac, but the name ranges look exactly right.

You might open up Name Manager (CRL-F3 on a PC) where you can see how Excel has setup your named ranges and see if anything looks out of place.