Vlookup Function Arguments are correct but nothing in cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try Ctrl and the key next to the figure 1 on the top row. This toggles
between showing formula and showing values.
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
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
 
I apologize to all for the multiple posts. I was having "Can not find
server" issues.
 

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

Similar Threads

VLOOKUP displays formula rather than result Excel 2007 2
VLOOKUP 2
Display results of formula 1
Vlookup Function 3
VLOOKUP with a Named Range argument 1
Trapping errors in a VLOOKUP function 1
Vlookup 1
VLOOKUP 1

Back
Top