LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default VLOOKUP displays formula rather than result Excel 2007

I entered a VLOOKUP function in a cell using the function wizard. In the
wizard window, the correct result is displayed but when I hit enter the
formula is entered in the cell but displays the formula rather than the
result. Auto calculate is on. Is there something else I need to do in Excel
2007 to get the result to display?

810 =VLOOKUP(D51,'Map Listing'!E1:H3256,4,false) US35161030

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula displays instead of text result emprof Excel Discussion (Misc queries) 2 September 3rd 08 02:48 AM
Vlookup displays wrong result Melbridge Excel Worksheet Functions 10 November 9th 07 12:37 AM
Cell Displays Formula, not result Melanie Excel Worksheet Functions 2 August 9th 06 05:40 PM
Cell displays formula, not result? ctc Excel Discussion (Misc queries) 4 June 12th 06 09:45 PM
Cell displays formula instead of result BAC Excel Discussion (Misc queries) 2 February 4th 06 06:08 PM


All times are GMT +1. The time now is 04:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"