VLOOKUP Formula - Needing it to ignore blank cell

Hello all,

Here's what I have in C5:

=VLOOKUP(B5,Sheet7!$A$1:$B$6,2)

The range for the VLOOKUP is:

0 Not qualified. Minimum standards and qualifications are not met.
1 Meets standards and qualification of some subcategories but a majority are below minimum standards.
2 Meets standards and qualifications in a majority of the subcategories but not all.
3 Meets standards and qualifications.
4 Exceeds standards and qualifications in most subcategories.
5 Exceeds standards and qualifications in each sub category.

But, in C5 it's returning the data for a 0. If B5 is blank, I want C5 to be blank.

Thank you!

Try

=VLOOKUP(B5,Sheet7!$A$1:$B$6,2,0)

However this will now return #N/A for a blank in B5..
So we can use IFERROR

=IFERROR(VLOOKUP(B5,Sheet7!$A$1:$B$6,2,0),"")

Thank you Jonmo1; however, what I'm looking for is a return in C5 based on the input in B5. I tried both forumulas but it still returned the data from the VLOOKUP for "0".

That probably means the resulting cell in column B in Sheet7 is Blank (or 0)

Originally Posted by newdoverman

This might meet your needs

Formula:

Please Login or Register  to view this content.

Yes! Thank you!