returning blank cell from vlookup

  • Thread starter Thread starter jume54
  • Start date Start date
J

jume54

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.
 
=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:

=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.
Click to expand...
 
Back
Top