Hello All,
I have a two conditional index match. The problem is the blank cells are returning errors. Could you please help me revise my formula so that the errors just show up as blanks? Thanks!
=INDEX(Index!$C$3:$E$5, MATCH('Relocation Details'!$H8, Index!$B$3:$B$5,0), MATCH('Relocation Details'!$I8, Index!$C$2:$E$2,0))
=iferror(INDEX(Index!$C$3:$E$5, MATCH('Relocation Details'!$H8, Index!$B$3:$B$5,0), MATCH('Relocation Details'!$I8, Index!$C$2:$E$2,0)))
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks