IFERROR / VLOOKUP - WANT BLANK CELL TO BE FALSE

Copper Contributor

=IFERROR(VLOOKUP($B$2,Hopkins!$A$3:$Q$36,15,FALSE),IFERROR(VLOOKUP($B$2,Percy!$A$3:$Q$36,15,FALSE),(VLOOKUP($B$2,Clinton!$A$3:$Q$36,15,FALSE))))

 

THE BLANK CELLS ARE RETURNING A 0 - WHICH IS NOT WHAT I WANT.  I WANT A BLANK CELL (0) TO BE FALSE SO IT GOES TO THE NEXT VLOOKUP

 

 

THANK YOU!

 

1 Reply

@KKRIS1050 

If Column 15, of your table_array contains numbers and blank cells, you may construct your VLOOKUP this way: 

=IFERROR(1/(1/VLOOKUP($B$2,Hopkins!$A$3:$Q$36,15,0)),

IFERROR(1/(1/VLOOKUP($B$2,Percy!$A$3:$Q$36,15,0)),

1/(1/VLOOKUP($B$2,Clinton!$A$3:$Q$36,15,0))))