vlookup speed question

[Dylan @ UAFC]

is there a large difference in speed when you
end your formula with TRUE verses FALSE

any suggestion with vlookup on increasing speed

 

[T. Valko]

Yes, if the lookup table is sorted.

See this:

http://decisionmodels.com/optspeede.htm

 

[Pete_UK]

Further to Biff's reply, sometimes the lookup table is sorted, but you
still need an exact match. In this case you still have to use FALSE or
0 as the 4th parameter.

Hope this helps.

Pete

 

[Charles Williams]

Thats not entirely correct Pete, its not too hard to do exact match using
the Sorted option of Vlookup or Match when the data is sorted.

see Sorted Data with Missing values at
http://decisionmodels.com/optspeede.htm for an explanation of how to do
this.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

Further to Biff's reply, sometimes the lookup table is sorted, but you
still need an exact match. In this case you still have to use FALSE or
0 as the 4th parameter.

Hope this helps.

Pete

 

[Pete_UK]

Ah yes, I had forgotten about that approach - thanks for reminding me,
Charles.

Will I see you at the User Group meeting in April?

Pete

 

[Charles Williams]

Yes, looking forward to the April conference. I am doing 2 sessions:

All about Names and their many different flavours
Speeding Up Excel

I wanted to do a session on efficient VBA UDFs because I have a lot of good
material, but we decided it was a bit too much VBA. Maybe next time.

See you there

regards
Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

Ah yes, I had forgotten about that approach - thanks for reminding me,
Charles.

Will I see you at the User Group meeting in April?

Pete