How to export data

[Zojo]

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

[shg]

Welcome to the forum.

See Help for the VLOOKUP function.

If that's not enough, please post an example workbook and explain in context.

[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

[shg]

In B2 and copy right and down, =VLOOKUP($A2, 'From here'!$A$1:$C$23, COLUMN(), FALSE)

[Zojo]

Thanks indeed!

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

[shg]

Did you try it?

[Zojo]

Sure i tried it. I copied the vlookup function you posted. But it says error.

[shg]

See attached.

[Zojo]

AAh solved it thanksThe problem was that my excel is hungarian and the function names are not the same

Thank you once agaion you helped me a lot

[shg]

You're welcome. Your English is infinitely better than my Hungarian ...

[StephenR]

And one must always be wary of Hungarian phrase books ...

[Zojo]

Just one more question. The abcd are names there are some situations that the names are the same, example: there are two or three Rob Thomas named guys. And i want to export the data from the second Rob Thomas. In our company there are unique id`s for every worker. So how can i make the excel if there are 3 Rob Thomases, to look for the id from the Import here table(suppose that i write the id to the selected Rob Thomas manually) and than export the datas to the columns.
So more easier if there are dublications in names, just to make sure that the right persons data is exported i write in his id and i want the excel to check not only the name but the id too

[shg]

Do the lookup on the IDs instead of the names, then retrieve the name and other information from the IDs.

[Zojo]

This sounds really clear and logic and simple, wonder why cant i solve such problems. (((Thoughts for myself)) THINK THINK THINK

[Zojo]

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