LinkBack URL
About LinkBacks
Hi,
Just wondering if anybody can help me hide if there is a error in my formula?
Thanks!
=INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),FALSE))
Hi,
Just wondering if anybody can help me hide if there is a error in my formula?
Thanks!
=INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),FALSE))
=IFERROR(INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),0)),"")try the above=IFERROR(INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),0)),"")
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Works the charm, thank you!Originally Posted by nflsales
=IFERROR(INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),0)),"")try the above=IFERROR(INDEX(AF4:AF210,MATCH(1,INDEX(($AA$4:$AA$210=$C$5)*($AC$4:$AC$210=$B$4),0),0)),"")
Be aware that :
IFERROR hides ALL errors, and sometimes errors you do not want to hide
To avoid this, enter your formula in a spare column ( eventually hidden- say col A) and let the NA happen
Then in your result column something like =if (isna(a1),0,a1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks