LinkBack URL
About LinkBacks
Can someone please help me to remove the "0" and "N/A" results from the following index match formula?!
=IF(ROW($A1)>$C1, "", INDEX(CONTACTS!I:I, MATCH($B$1 & "-" & ROW($A1), CONTACTS!$P:$P, 0)))
Can someone please help me to remove the "0" and "N/A" results from the following index match formula?!
=IF(ROW($A1)>$C1, "", INDEX(CONTACTS!I:I, MATCH($B$1 & "-" & ROW($A1), CONTACTS!$P:$P, 0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks