View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Code Numpty Code Numpty is offline
external usenet poster
 
Posts: 94
Default VLOOKUP formula results strange after copying down

Excel 2003 - I have a VLOOKUP formula which I have copied down the column.
When I check the formula it has copied down correctly, yet the result
returned is that for the first cell in the column for every single one.

To get the correct result I have to double-click every single cell
containing the formula, which will then show the correct result.

This has only started happening recently. Has Excel corrupted in some way?