hi all

Quick question - or at least I Hope it is!!

When using a VLookUp table, does the lookup table itself have to be sorted
by the left-hand column in order for the formulas to work?

I thought it did, however, one of my colleagues informs me that if you put
'FALSE' as the last value in the lookup, the table doesn't have to be sorted
at all.

Hope this makes sense.

Any help would be appreciated.

Thank you.

Louise