Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup query after using fill
I used vlookup to find and display a particular cell. This worked fine. I
then use the fill functionality to copy this formula to the columns below. This seems to work ok with the correct formula being shown in each column but the result in each of the columns below was the same as the first cell in the column. When i went into each of the cells below and pressed enter the correct results then appeared - do i need to do some kind of refresh to sort this problem out ? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup query after using fill
Try changing settings in
Tools(MENU)- Options(SUB-MENU)- Calculation(TAB)- Automatic (Radio Button). Please rate me. "davemel" wrote: I used vlookup to find and display a particular cell. This worked fine. I then use the fill functionality to copy this formula to the columns below. This seems to work ok with the correct formula being shown in each column but the result in each of the columns below was the same as the first cell in the column. When i went into each of the cells below and pressed enter the correct results then appeared - do i need to do some kind of refresh to sort this problem out ? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup problem with Access Query import into Excel 2000 | New Users to Excel | |||
VLOOKUP QUERY | Excel Discussion (Misc queries) | |||
VLOOKUP Query | Excel Worksheet Functions | |||
fill handle + query | Excel Worksheet Functions | |||
Non-sequential VLOOKUP function -OR- sequential sort of web query | Excel Worksheet Functions |