| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert VLOOKUP to absolute cell reference
My spreadsheet has a VLOOKUP through 44,000 rows that only needed to be
performed once. The relevant data is in the VLOOKUP cells as I want them and the lookup values will never change. As long as I keep the other worksheet intact, can I convert the VLOOKUP formulas to absolute references? My spreadsheet is running very slow with the VLOOKUP in place, so I'm trying to speed things up. Would this idea work? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Apply a simple formula to multiple rows? | New Users to Excel | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| cell reference show cell name (ie. D45) and not cell value | Excel Worksheet Functions | |||
Threaded Mode
