Formula - vlookup or other

[Irma Norminton]

I have a spreadsheet with clients database containing information such as their classifications according to our criteria, nationality, rural or urban, address, sector etc. The same information is used in a second spreadsheet. I am looking for a formula by which I can for instance insert the name of the client and the rest of the information from the original spreadsheet are copied and placed in the second sheet.

I do not even know where to start?

Your assistance would be greatly appreciated.

Irma

 

[Marcelo Branco]

Hi and welcome to Mr Excel Forum

Take a look at
Excel VLookup Function Examples

M.