Excel as invoice - customer says addresses used to be remembered on old PC

I’ve no idea what he is taking about and it was weeks ago this was mentioned

He went from an old version of office on a win xp pc to office 2016. Old pc dead. I can’t see an example of this.

When doing excel invoices the addresses appeared I think when he typed the first name of the person perhaps and were easy to place. He is not very technical

I’m on site later but I don’t have the old PC to look at, it’s dead

Anyone any idea what he is taking about ?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rob HensonFinance AnalystCommented:
As far as I can think, Excel can't "remember" things but items can be stored in a list which can then be used as a lookup list.

For example if your list of customers has columns for:
  Customer Reference
  Customer Name
  Customer Address (could be multiple columns for street, town, postcode etc)

By entering Customer reference on an invoice, the name and address can be populated by a lookup formula.

Maybe this is what your colleague is referring to.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.