Perhaps, if you insert rows into your existing lookup range reference, your
formulas will update automatically.

HTH,
Bernie
MS Excel MVP

"MM" wrote in message
...