HLOOKUP and VLOOKUP

[Patrick Durusau <patrick@durusau.net>]

Andreas,

Francis and I are puzzling over the last two sentences in HLOOKUP and 
VLOOKUP, both of which read:

"If DataSource is not sorted, the result is undetermined and 
implementation-dependent. In most cases it will be arbitrary and just 
plain wrong due to binary search algorithms."

We can just require the DataSource to be sorted and fall silent about 
what happens when it's not sorted.

The final sentence, " In most cases it will be arbitrary and just plain 
wrong due to binary search algorithms.", in any event, seemed like a odd 
statement to have in a standard. Yes?

Thanks!

Hope you are about to start a great weekend!

Patrick

--
Patrick Durusau
patrick@durusau.net
Technical Advisory Board, OASIS (TAB)
Editor, OpenDocument Format TC (OASIS), Project Editor ISO/IEC 26300
Co-Editor, ISO/IEC 13250-1, 13250-5 (Topic Maps)

Another Word For It (blog): http://tm.durusau.net
Homepage: http://www.durusau.net
Twitter: patrickDurusau

Attachment: OpenPGP_signature
Description: OpenPGP digital signature