Excel allows 65,536 rows. Look up tables can be on other sheets.
Have you thought of using a database app like Access?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Rodney" wrote in message
...
I need a min of 50,000 rows
and lookup tables.
any thoughts, ideas, hints.
Thanks