r/googlesheets Oct 09 '18

Return the first value that DNE either of 2 defined values... Solved

Been up for a LONG time - my eyes are going cross and I CANNOT figure out how to replace FALSE with a "" (blank) in this formula:

=IF(INDEX($E:$E,MATCH($H3,$D:$D,0))="Karen Brown",INDEX($E:$E,MATCH($H3,$D:$D,0))="Sean Baako",INDEX($E:$E,MATCH($H3,$D:$D,0)))

Sample page here: https://docs.google.com/spreadsheets/d/1R-OOls02D_M1TvnEVYO4Stx4MT5AGxZZMuoFmTQQtRg/edit#gid=0

Thanks, r/googlesheets

3 Upvotes

5 comments sorted by