VLookup is odd

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Ok, I have a VLOOKUP function that works, but here's what
is weird. It's giving me all 0's. When I go and double
click the cell that contains the lookup value it goes into
an edit. If I hit enter, then the VLOOKUP function works.
I didn't change the value of the lookup cell at all. Why
would it do this? Is there a way to get it working right
without having to go 1 by 1 and double clicking the cell
and hitting enter? Thank you.
 
I would check to see if Excel is set to manual
calculation. Go to Tools > Options > Calculation tab and
make sure the "Automatic" box is checked.

HTH
Jason
Atlanta, GA
 
Rob said:
Ok, I have a VLOOKUP function that works, but here's what
is weird. It's giving me all 0's. When I go and double
click the cell that contains the lookup value it goes into
an edit. If I hit enter, then the VLOOKUP function works.
I didn't change the value of the lookup cell at all. Why
would it do this? Is there a way to get it working right
without having to go 1 by 1 and double clicking the cell
and hitting enter? Thank you.
Click to expand...

It's probably that the lookup value is a number and where it's looking is
text. As long as the cell is not formatted as text, when you edit a with
text in it that looks like a number (even without actually changing
anything), the result is a number rather than text. To do this to many cells
all at once, copy a blank cell (that is not formatted as text). Select all
the cells you want to change and use
Edit > Paste Special > Add.
 
make sure that the calulation function has not been set to
manual (which you are resettung when you edit the
individucal cells.)
 
Thanks, Paul. That worked.
-----Original Message-----


It's probably that the lookup value is a number and where it's looking is
text. As long as the cell is not formatted as text, when you edit a with
text in it that looks like a number (even without actually changing
anything), the result is a number rather than text. To do this to many cells
all at once, copy a blank cell (that is not formatted as text). Select all
the cells you want to change and use
Edit > Paste Special > Add.


.
Click to expand...
 
Back
Top