Hi Moglione1,

I have a file with over 70'000 rows in (MS EXCEL only holds around
65'000). Is there any way I can still perform a lookup on this file.

The file is saved as a CSV. Please dont tell me to open it in Wordpad
and do a search as I have been told this is not acceptable. (Pains).

Yes, try Data, Get external data, New database query and follow
instructions from there.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com