Thread: VLOOKUP formula results strange after copying down
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default VLOOKUP formula results strange after copying down
Post an example of your formula - you might have used absolute
addressing for the lookup value, so that you are always looking for
the first cell. Perhaps your table range is not quite what you think
it should be.

Hope this helps.

Pete

On Jul 31, 12:10*am, CaptSpify
wrote:
I've got the same issue, except that my automatic Calculation IS turned on.
Reply With QuoteReply With Quote