IFERROR / VLOOKUP - WANT BLANK CELL TO BE FALSE

%3CLINGO-SUB%20id%3D%22lingo-sub-1223887%22%20slang%3D%22en-US%22%3EIFERROR%20%2F%20VLOOKUP%20-%20WANT%20BLANK%20CELL%20TO%20BE%20FALSE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1223887%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIFERROR(VLOOKUP(%24B%242%2CHopkins!%24A%243%3A%24Q%2436%2C15%2CFALSE)%2CIFERROR(VLOOKUP(%24B%242%2CPercy!%24A%243%3A%24Q%2436%2C15%2CFALSE)%2C(VLOOKUP(%24B%242%2CClinton!%24A%243%3A%24Q%2436%2C15%2CFALSE))))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHE%20BLANK%20CELLS%20ARE%20RETURNING%20A%200%20-%20WHICH%20IS%20NOT%20WHAT%20I%20WANT.%26nbsp%3B%20I%20WANT%20A%20BLANK%20CELL%20(0)%20TO%20BE%20FALSE%20SO%20IT%20GOES%20TO%20THE%20NEXT%20VLOOKUP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1223887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1224058%22%20slang%3D%22en-US%22%3ERe%3A%20IFERROR%20%2F%20VLOOKUP%20-%20WANT%20BLANK%20CELL%20TO%20BE%20FALSE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1224058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579860%22%20target%3D%22_blank%22%3E%40KKRIS1050%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Column%2015%2C%20of%20your%20table_array%20contains%20numbers%20and%20blank%20cells%2C%20you%20may%20construct%20your%20VLOOKUP%20this%20way%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIFERROR(1%2F(1%2FVLOOKUP(%24B%242%2CHopkins!%24A%243%3A%24Q%2436%2C15%2C0))%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EIFERROR(1%2F(1%2FVLOOKUP(%24B%242%2CPercy!%24A%243%3A%24Q%2436%2C15%2C0))%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E1%2F(1%2FVLOOKUP(%24B%242%2CClinton!%24A%243%3A%24Q%2436%2C15%2C0))))%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

=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))))