View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cyberlill cyberlill is offline
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