| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Q: Is this vlookup statement efficient?
=VLOOKUP($N17&" Total",DVD_Catalog,4,FALSE)
Is this function's range argument, "DVD_Catalog", too non-specific? I.e, would assigning a range (DVD_Catalog!a1:z1) be faster...or does Excel default to looking up values in the first column only when there is no range given, in which case there would not be any signficant performance improvement? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's themost efficient way | Excel Worksheet Functions | |||
| Efficient linking | Excel Discussion (Misc queries) | |||
| IF and VLOOKUP - how efficient? | Excel Worksheet Functions | |||
| What is more efficient | Excel Discussion (Misc queries) | |||
| More efficient code | Excel Programming | |||
![John[_60_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
