Mar 11 2020 06:59 PM - edited Mar 11 2020 06:59 PM
=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!
Mar 11 2020 11:10 PM
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))))