Hi Aztiguen,

You could limit the lookup range to the data already input. Alternatively, you can copy the results of your lookup formula and convert it to its results via Paste Special > Values.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]