Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with all the same values in one column
I found one reason the vlookups weren't working for me. I did the formula
correct in cell 2. Then I copied that formula and paste---paste special--- formula in cell 2. Then I doubleclicked cell 2 the box on the bottom right. That does copy the formula to all the cells in the column I'm tryint to lookup. I noticed a weird thing. All the values in the column are the same as cell 1. Then when I click on each cell individually it updates it to the right match in the vlookup. This took me a long time to figure out becuase I thought Excel automatically updated cells. Am I not doing the copy/paste special/formula right. I want to put the vlookup formula in all the cells in the column. thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with all the same values in one column
Try ...
Tools - Options - Calculation - Automatic ... May be set to "Manual" "Janis" wrote: I found one reason the vlookups weren't working for me. I did the formula correct in cell 2. Then I copied that formula and paste---paste special--- formula in cell 2. Then I doubleclicked cell 2 the box on the bottom right. That does copy the formula to all the cells in the column I'm tryint to lookup. I noticed a weird thing. All the values in the column are the same as cell 1. Then when I click on each cell individually it updates it to the right match in the vlookup. This took me a long time to figure out becuase I thought Excel automatically updated cells. Am I not doing the copy/paste special/formula right. I want to put the vlookup formula in all the cells in the column. thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup with all the same values in one column
no wonder none of my vlookups ever worked, thanks, :-)
"Ken" wrote: Try ... Tools - Options - Calculation - Automatic ... May be set to "Manual" "Janis" wrote: I found one reason the vlookups weren't working for me. I did the formula correct in cell 2. Then I copied that formula and paste---paste special--- formula in cell 2. Then I doubleclicked cell 2 the box on the bottom right. That does copy the formula to all the cells in the column I'm tryint to lookup. I noticed a weird thing. All the values in the column are the same as cell 1. Then when I click on each cell individually it updates it to the right match in the vlookup. This took me a long time to figure out becuase I thought Excel automatically updated cells. Am I not doing the copy/paste special/formula right. I want to put the vlookup formula in all the cells in the column. thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
problems with displaying "duplicate vlookup values" in same column | Excel Discussion (Misc queries) | |||
Advanced Filter for Values in Column M greater than Values in Colu | Excel Discussion (Misc queries) | |||
Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions |