View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sal Sal is offline
external usenet poster
 
Posts: 84
Default Vlookup function

Greetings,

I have two large spreadsheets that were created by downloading data from
another application. I am trying to link data between the spreadsheets with
the vlookup function. When I enter the formula manually it works, but when I
copy it down it gives the same value as the cell I copied it from even though
the lookup_value changes accordingly in the copied cell. If I simply edit
the copied cell and write over what appears as the same exact lookup_value
the correct value shows up. Has anyone fixed this type of problem before
where in a vlookup formula the lookup_value has to be manually entered to
work? Thanks!

--
SAL