Thread: MS Excel wizz's Is there a script for?
View Single Post
  #5  
Old 04-23-2009, 06:03 PM
Glennrf38 Glennrf38 is offline
Member
  
Join Date: Jul 2006
Location: Calgary
Posts: 332
Glennrf38 is on a distinguished road
Default
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.
__________________
150 G mixed reef.
Reply With Quote