View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Vlookup is displaying the formula in its cell not the result??

Perhaps the cell is formatted as text. Change it to General, then do an
F2-Enter.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Craig H" <Craig wrote in message
...
Vlookup is displaying the formula in its cell not the result??

In excel I can't get the V-lookups I'm running to show their reaults, when
creating the vlookup the result is display, but the result doesn't show in
the cell with the formula??

Any ideas welcomed??

Thanks Craig