2 Sheets, each sheets has IDs, I need to match IDs and write information from sheet 2 to sheet 1.

[Ergiler]

Hello,

I have 2 sheets, sheet1 named Working has currently working people in the company. Sheet2, named Education, has all that have ever worked in the company.
Both sheets have names and work IDs, I personally try to match the work IDs. Sheet with Education has currently achieved Education level of the workers and I need to move that information to the Working sheet, and to the right worker, through the working IDs/names.

So far I was able to use MATCH function to pinpoint the right row with matching ID in the collum

=MATCH(C20;Education!C:C;0)

. I know it can be made better so I am asking for the advice.

Forum recommended me post with name "Matching Student ID with respective name" but I am honestly not very good with excel so I was not able to make it work.

I will be happy for any help.

 

[Ergiler]

Hello,

I have 2 sheets, sheet1 named Working has currently working people in the company. Sheet2, named Education, has all that have ever worked in the company.
Both sheets have names and work IDs, I personally try to match the work IDs. Sheet with Education has currently achieved Education level of the workers and I need to move that information to the Working sheet, and to the right worker, through the working IDs/names.

So far I was able to use MATCH function to pinpoint the right row with matching ID in the collum

=MATCH(C20;Education!C:C;0)

. I know it can be made better so I am asking for the advice.

Forum recommended me post with name "Matching Student ID with respective name" but I am honestly not very good with excel so I was not able to make it work.

I will be happy for any help.

Sorted with Index