MS Excel wizz's Is there a script for?

[brizzo]

Originally Posted by Glennrf38

Nazarine. You almost have it. change the ranges from $A$1:$B:$B1000 to just A$:B$
It actually makes the vlookup a bit faster. Other than that I agree. I think that is the best way unless he goes with VBA. Depending on what he is looking for.

Nice!! I was always wondering if there was a better way than a specific table range. That tip will help with some of my dynamic sheets that have data pulled from a database.