Hello everybody,

could anyone help me?

A1 should be a list of numbers from 2 to over 500001 and B1 should be that
hat i will be looking for entering a number form the first column in an other
worksheet. Cause of only 65000 rows I cannot use vlookup. Is it possible to
split in a "table_array". I'm looking for easiest way, cause i'm the beginner
in using function.

Thanks in advance


--
Daniel from Poland