Well done, Shane -- This is a good thing to point out about VLOOKUP. Thanks.

Shane Devenshire wrote:
Sheeloo,

You are not entirely "thinking wrongly"

If

=VLOOKUP(A1,Table,2,) is entered Excel assumes the 4th argument is False
but
=VLOOKUP(A1,Table,2) is entered Excel assumes the 4th argument is TRUE

Cheers,
Shane Devenshire