If Formula

I am working daily on a worksheet with names and other personal information for clients such as identity numbers, physical as well as postal address and telephone numbers. Would you kindly help with formulas which I can use so that when I enter the client's reference number all the other details are automatically filled to another blank document

Nick's picture

VLOOKUP

Get familiar with VLOOKUP... more info here:

13. Excel Tips - VLOOKUP

Teach Yourself Excel Lesson 22 - VLOOKUP Formula