VLookup occasionally returns formula with no data

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

Guest

Okay so I've done many many complicated vlookups in my life time.. But
occasionally when I use one after done with the formula it returns the
formula and not the results. Any help on if there is a setting in Excel that
I need to turn off??

Here is what I'm getting for
results"=VLOOKUP(B2,[customera.xls]Sheet1!$A:$B,2,0)"

Please help
 
Maybe:-

Tools|Options|View and un-check formulas

Or shortcut

CTRL + ` (The ` is to the left of the 1 key)

Or maybe the cell is text so change to General hit F2 and enter.

Mike
 
Mike H;
You know I swear that I tried that and it didn't work so I just tried
something new... Changed to General and saved both files.. Still same
problem.. Then shut down excel and reopened it.. .Bang when I re-inserted the
Vlookup it worked.. Also I did not change any setting under options as they
were all fine..

Thanks for your help

Ted

Mike H said:
Maybe:-

Tools|Options|View and un-check formulas

Or shortcut

CTRL + ` (The ` is to the left of the 1 key)

Or maybe the cell is text so change to General hit F2 and enter.

Mike
Ted Jillett said:
Okay so I've done many many complicated vlookups in my life time.. But
occasionally when I use one after done with the formula it returns the
formula and not the results. Any help on if there is a setting in Excel that
I need to turn off??

Here is what I'm getting for
results"=VLOOKUP(B2,[customera.xls]Sheet1!$A:$B,2,0)"

Please help
Click to expand...
Click to expand...
 
ah! the infamous reboot cure. I still often spend way too much time trying
other things before trying this and having it work.

Ted Jillett said:
Mike H;
You know I swear that I tried that and it didn't work so I just tried
something new... Changed to General and saved both files.. Still same
problem.. Then shut down excel and reopened it.. .Bang when I re-inserted the
Vlookup it worked.. Also I did not change any setting under options as they
were all fine..

Thanks for your help

Ted

Mike H said:
Maybe:-

Tools|Options|View and un-check formulas

Or shortcut

CTRL + ` (The ` is to the left of the 1 key)

Or maybe the cell is text so change to General hit F2 and enter.

Mike
Ted Jillett said:
Okay so I've done many many complicated vlookups in my life time.. But
occasionally when I use one after done with the formula it returns the
formula and not the results. Any help on if there is a setting in Excel that
I need to turn off??

Here is what I'm getting for
results"=VLOOKUP(B2,[customera.xls]Sheet1!$A:$B,2,0)"

Please help
Click to expand...
Click to expand...
Click to expand...
 
Back
Top