I am most likely no better than you at troubleshooting your Vlookup problem,
but if you want I would look it over if you sent me an example workbook.

Regards,
Howard

"Bluewolf" wrote in message
...
If I knew how I would put up a couple of files so the helpfull could see
the
problem.
--
A charming and handsome, highley intelectual adept levle Excel user.


"Bluewolf" wrote:

I have a problem with VLOOKUP looking in sorted lists of more than 16384
items.
Basically it fails at 16385th item

I have developed a VLOOKUP function that looks up in multiple tabs in
multiple files and returns a value. However I have discovered that it
fails
at row 16385. As Excel copes to 64,000 rows I regard this as a bug. Has
anyone else encounteed this problem? is it just my machine, is there a
solution / bug fix?

If I use FALSE when the item to be found is beyond 16384 the function
returns the 16384th value this is a warning to other users who may not
have
noticed as I did not initially.
--
A charming and handsome, highley intelectual adept levle Excel user.