MS Excel wizz's Is there a script for? - Canreef Aquatics Bulletin Board

04-23-2009, 07:03 PM

Glennrf38

Member

Join Date: Jul 2006

Location: Calgary

Posts: 332

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.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump

All times are GMT. The time now is 01:22 AM.