need to match data from 2 different sheets

[Guest]

Hi all,

I have a spreadsheet with 2 sheets: sheet 1 contains: colum 2: name, colum3:
surname, and a lot of other colums with extra info per person. I need to
insert an ID number into the first colum.
Sheet 2 contains: colum 1: ID number, colum 2: name, colum 3: surname, and
contains a lot more rows than the first sheet (and sometimes has a number of
people with the same surname)
Can anyone help me with writing a formula to go into the first colum of the
sheet1?

Thanks,
Karolien

 

[Ronx]

Suggest you post to a forum appropriate to the spreadsheet., such as
microsoft.public.excel
Here, microsoft.public.frontpage.client, you get help with web pages
and FrontPage, not spreadsheets.