Vlookup Function Arguments are correct but nothing in cell

T

Tom

I have a VLOOKUP function in my excel worksheet. I built it using the
wizard. When I look at the function argument wizard, the function result
value at the bottom is correct. However, in my cell it simply returns the
function equation and not the value. I even hit F9 and nothing happened.

Since the wizard appears to be returing the right value, how do I get the
cell to execute the function?
 
R

Rae Drysdale

Try Ctrl and the key next to the figure 1 on the top row. This toggles
between showing formula and showing values.
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 
B

BruceP

It is possible that you accidentally hit CTRL+ ` (the key just to the
left of the 1). If you hit that combination again, it should turn off
the Formula View.

HTH

Bruce
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top