Index and Match formula for numbers help

=((INDEX('AJ Code'!D2:D1001,MATCH(1,INDEX(('AJ Code'!B2:B1001=$I$3)*('AJ Code'!C2:C1001=$J$3),0,1),0))))

This is a formula I have been using for years in excel and just made the switch today to a macbook pro and I have been trying for 90 minutes to figure out how to get this to work in numbers. Any help would be greatly appreciated. Thanks in advance.

MacBook Pro with Retina display, iOS 8.1

Posted on Oct 22, 2014 6:01 PM

16 replies

SGIII

Level 8

37,562 points

Oct 23, 2014 6:21 PM in response to ajeagle6921

In Excel an array formula will display with { } around it. It's a special type of formula that Numbers can't handle. This one looks as if it might be an array formula.

If you're trying to do a lookup on two values, one workaround is to concatenate the two columns and do a lookup on the concatenated value.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Index and Match formula for numbers help

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up