thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I can't figure out the configuration for the "IFNA" formula to rid this example of its "N/A" value. Can anyone help?
=(INDEX(FORMULA2!$I$58:$I$93,MATCH(AO5,IF(FORMULA2!$B$58:$B$93=AP5,FORMULA2!$A$58:$A$93),0)))
I can't figure out the configuration for the "IFNA" formula to rid this example of its "N/A" value. Can anyone help?
=(INDEX(FORMULA2!$I$58:$I$93,MATCH(AO5,IF(FORMULA2!$B$58:$B$93=AP5,FORMULA2!$A$58:$A$93),0)))