S
SAL
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!
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!