returning blank cell from vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jume54 - 16 Sep 2007 20:39 GMT

I'm hoping someone can help me with this problem. Is it possible to
have a blank cell returned when using the following formula:

=VLOOKUP(G2,$AA$3:$AB$7,2,TRUE)

The lookup table is:

0    Level 1: Below Basic
4    Level 2: Basic
6    Level 3: Proficient
8    Level 4: Goal
10    Level 5: Advanced

If G2 has no value entered yet, I would like the formula to return
just a blank cell. As it works now, it returns the lowest value, i.e.
"Level1: Below Basic" Thanks for the help.

Reply to this Message

Dave Peterson - 16 Sep 2007 20:46 GMT

=if(g2="","",vlookup(....))

> I'm hoping someone can help me with this problem. Is it possible to
> have a blank cell returned when using the following formula:
[quoted text clipped - 12 lines]
> just a blank cell. As it works now, it returns the lowest value, i.e.
> "Level1: Below Basic" Thanks for the help.

Signature

Dave Peterson

Reply to this Message

jume54 - 16 Sep 2007 21:03 GMT

Perfect! Thanks!!

>=if(g2="","",vlookup(....))
>
[quoted text clipped - 14 lines]
>> just a blank cell. As it works now, it returns the lowest value, i.e.
>> "Level1: Below Basic" Thanks for the help.

Reply to this Message