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 |
Vlookup function
SAL,
Did you make the second argument (the table) absolute? You didn't give your formulas. We're all sitting around here coming up with theories why you didn't do that. But here are some guesses =VLOOKUP(A2, G2:H200, 2) should be =VLOOKUP(A2, $G$2:$H$200, 2) -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "SAL" wrote in message ... 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 |
Vlookup function
The table was a defined named range and the defined name was entered for the
the table. -- SAL "Earl Kiosterud" wrote: SAL, Did you make the second argument (the table) absolute? You didn't give your formulas. We're all sitting around here coming up with theories why you didn't do that. But here are some guesses =VLOOKUP(A2, G2:H200, 2) should be =VLOOKUP(A2, $G$2:$H$200, 2) -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "SAL" wrote in message ... 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 |
Vlookup function
Hi
Is ToolOptionsCalculationset to Automatic ? -- Regards Roger Govier "SAL" wrote in message ... The table was a defined named range and the defined name was entered for the the table. -- SAL "Earl Kiosterud" wrote: SAL, Did you make the second argument (the table) absolute? You didn't give your formulas. We're all sitting around here coming up with theories why you didn't do that. But here are some guesses =VLOOKUP(A2, G2:H200, 2) should be =VLOOKUP(A2, $G$2:$H$200, 2) -- Earl Kiosterud www.smokeylake.com Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already top-posted, the thread gets messy. When in Rome... ----------------------------------------------------------------------- "SAL" wrote in message ... 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 |
All times are GMT +1. The time now is 12:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com