| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No autofill VLookup function
Hi,
I am using a vlookup to extract comments relating to particular ref. no's from a seperate worksheet. The vlookup has been created and works for one cell. However, when I try to autofill it down it copies the formula OK but the results don't change. Whne I double click in each cell and press enter the formula seems to refresh and starts to work. There are over 600 instances so this will take some time! Please help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pastable function using VLOOKUP? | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| Help with VLookup function | Excel Worksheet Functions | |||
| Using the autofill function but increment by certain number in function | Excel Worksheet Functions | |||
| Vlookup w/Date Function | Excel Worksheet Functions | |||
Threaded Mode
