index match #n/a error

Hi expert's excel 2007

trying to complete an index match off a pivot table...getting #n/a error

=index($a$2:$ae$17,match(a33, $a$33:$a$42,0),match($c$32:$j$32))

$a$2:$ae$17 pivot table data range

Microsoft Excel

Last Comment

route217

8/22/2022 - Mon

Saqib Husain

1/8/2014

You have not provided the actual formula. The second match formula contains insufficient arguments and is not accepted by excel.

You will have a better response if you upload a sample file.

ASKER CERTIFIED SOLUTION

Saqib Husain

1/8/2014

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

route217

1/8/2014

ASKER

Ssaqib...worked it out....

How would I amend to handle #n/a error. ..

=if(isna(index($a$2:$ae$17,match(a33, $a$33:$a$42,0),match(c31,$c$32:$j$32)),"",index($a$2:$ae$17,match(a33, $a$33:$a$42,0),match($c$32:$j$32)))

Saqib Husain

1/8/2014

That formula should be

=IF(ISNA(INDEX($A$2:$AE$17,MATCH(A33, $A$33:$A$42,0),MATCH(C31,$C$32:$J$32))),"",INDEX($A$2:$AE$17,MATCH(A33, $A$33:$A$42,0),MATCH(C31,$C$32:$J$32)))

if you have 2007 or later you may simplify it to

=IFERROR(INDEX($A$2:$AE$17,MATCH(A33,$A$33:$A$42,0),MATCH(C31,$C$32:$J$32)),"")

This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.

rwheeler23

route217

1/8/2014

ASKER

Thanks. ...for the feedback. ..

can you shed some light on https://www.experts-exchange.com/questions/28333198/extract-text-string-using-formula-excel-2007.html

Certified Expert Program

Credly Partnership

Udemy Partnership