| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fill down error for Vlookup
Hi,
I have created a VLOOKUP formula which creates the correct answer for me. However, i need to fill down the formula for the whole spreadsheet (about 38,000 rows) that i am working on. When i do this it moves the lookup table down one row each time i fill. Is there some way that i can copy or fill down the formula without having the lookup table in the formula change with every row? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
| Auto Fill Options | Excel Discussion (Misc queries) | |||
| fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
