Issue with Nested IF(ISNA(INDEX(MATCH Equation

[djobiii]

I have scoured the Internet and I fell like this equation is correct, but there is something not right. I have three Access Database Queries that cannot be merged and I am using:

IF(ISNA(INDEX(InstallQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,InstallQuery!B:B,0))),IF(ISNA(INDEX(CableQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0))),INDEX(SiteSurveyQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,SiteSurveyQuery!B:B,0)),INDEX(CableQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0))),INDEX(InstallQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,InstallQuery!B:B,0)))

to check all 3 sheets and return data to specific field. I have tested the logic, and I am at my wits end!! Please help me if you can!!!

 

[JustynaMK]

Hi djobiii,

If the priority of your INDEX/MATCH query is as follows:
InstallQuery -> if NA -> CableQuery -> if NA -> SiteSurveyQuery

Then maybe try working with the following formula:
=IFERROR(INDEX(InstallQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,InstallQuery!B:B,0)),IFERROR(INDEX(CableQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0)),INDEX(SiteSurveyQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,SiteSurveyQuery!B:B,0))))

 

[djobiii]

Hi djobiii,

If the priority of your INDEX/MATCH query is as follows:
InstallQuery -> if NA -> CableQuery -> if NA -> SiteSurveyQuery

Then maybe try working with the following formula:
=IFERROR(INDEX(InstallQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,InstallQuery!B:B,0)),IFERROR(INDEX(CableQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0)),INDEX(SiteSurveyQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,SiteSurveyQuery!B:B,0))))

That is closer. It I returning Values from 2 of the sheets. InstallQuery and SiteSuveyQuery, but I am still getting #N/A for the CableQuery. My equation was only returning values from the InstallQuery.
Let me know what you think? Thank you!!

 

[JustynaMK]

Good progress!
Then you need to investigate this component separately:
=INDEX(CableQuery!F:F,MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0))

...or even simply check if MATCH is returning an error and you will have your answer:
=MATCH('Install Report Week 8.5.18'!A2,CableQuery!B:B,0)