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

On Jan 20, 5:50*pm, "Charles Williams"
wrote:
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 athttp://decisionmodels.com/optspeede..htmfor an explanation of how to do
this.

Charles
___________________________________
The Excel Calculation Sitehttp://www.decisionmodels.com

"Pete_UK" wrote in message

...
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

On Jan 20, 5:03 pm, Dylan @ UAFC
wrote:



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

any suggestion with vlookup on increasing speed- Hide quoted text -

- Show quoted text -