Recent content by prendo

Vlookup is fine if your data is laid out right to left and sorted. Otherwise the results can be incorrect. There is a comprehensive of the pro's and con's In excljet.net - google vlookup caution sort and you'll find it. An alternative is to use the so-called Index Match. This is a combination...

As evening falls, we go in search of light entertainment or inspiration . . . I started using Access with version 2K. I have designed and developed several applications which have been destined for other users, and continue to be surprised by the capacity, ingenuity and knowledge of forum...