How to export data

Hello Everybody!

My question is related to my work. I have to match the name of colleuges with the birthdate, id number and A B C D category. Now I have to excel tables one with the names participated in company programs one with all the names in the company and the above listed information.
I want to know how can the excel automatically match these datas without copy pasting it from one to another. I mean to search for the name in the second table and if its matching to fill the birthdate id and ABCD category automatically.

I would greatly appriciate if you could help me, it would make my life much more easier.

ZOJO

HI i attached a sample table.

So in the first sheet there are names i named them a b c d etc. on the second sheet there are a list of all the names and there are values from 0-9 and birth dates. I want to export the values and birth dates to the first sheet to the matching names a b c d etc. Hope its understandable explanation.
Thanks For Your Help

Bye

ZOJO

Thanks indeed!

But there is an error at the Column() i think. Or what should i write there?

Hello Again!

Im having problems with the vlookup function when i want to use it with my table which contains a lot of data. If you would be so kind that you gave me your email address i would greatly appreciate it, because the excel file is around 10 mb. And i would explain what data do i need from one table to the other table. Please help me in this because my boss gave me this task and im a bit scared, because im bored with copy pasting.
Thank You!

Zojo