Excel 2007 : Returning blank cell if VLOOKUP has no value

**SilverZero** · 06-23-2011, 06:51 PM

I'm trying to use VLOOKUP to enter a grade point value based on a letter grade, then multiply it by the credit weight of a class (in an adjacent cell), BUT I just want a blank cell returned if there is no value, so the empty cells don't mess up a SUM formula that's also going on.

Please Login or Register  to view this content.

...works fine to take the letter grade in L5, look it up in the "Points" titled range and return the value, then multiply it by the credits in J5. But as soon as I try to wrap it all in an IFERROR function, it tells me I have too few arguments:

Please Login or Register  to view this content.

I was trying to follow this method. Should I be trying IF(ISNA)?

Thanks!

**tigeravatar** · 06-23-2011, 06:53 PM

SilverZero,

You have an unnecessary ")" after the *J5, just remove that and it should work:
=IFERROR(VLOOKUP(L5,Points,2,FALSE)*J5, "")

Hope that helps,
~tigeravatar

**SilverZero** · 06-23-2011, 06:56 PM

Sigh . . . it's always the little things. I guess I was trying to make sure the multiplier was included in the whole calculation, so I was wrapping things in too many parentheses. Whatever, that's perfect. Thank you so much!

I am amazed at how fast people respond and help out around here. This is like live chatting.

**tigeravatar** · 06-23-2011, 06:59 PM

You're very welcome

Getting back to you in 2 minutes is admittedly unusually quick for me, heh. I just happened to search for new posts almost immediately after you started the thread.