copy data automatically from one tab to another if criteria met

[JensBCN]

Hello from Barcelona,

just signed up ... my first question ... excited

I have 2 tabs. Tab 1 shows in column B the employee number and in column F a project name.

Tab 2 shows in column C the employee number (named "Codigo") as well and in column F the project name.

This project name needs to be copied if employee number matches.
Copied automatically into a blank field ... see red arrow Tab2

TAB1


Nr.Empleo (above) = Codigo (below)

TAB2



Looking forward to a smart solution.

Thanks / Jens

 

[vletm]

@JensBCN ... something like this:
Your 'Sheet1'

You could use [D2] kind of formula with 'Sheet2' and copy it down

... and maybe ";" need to be ","
ps. everyone likes sample files

 

[Hui]

Would the techniques discussed below assist?

Single Criteria
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
Multiple Criteria (Read the Single Criteria first)
http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

 

[JensBCN]

the file I am talking about ...

Hello from Barcelona,

just signed up ... my first question ... excited

I have 2 tabs. Tab 1 shows in column B the employee number and in column F a project name.

Tab 2 shows in column C the employee number (named "Codigo") as well and in column F the project name.

This project name needs to be copied if employee number matches.
Copied automatically into a blank field ... see red arrow Tab2

TAB1
View attachment 28742

Nr.Empleo (above) = Codigo (below)

TAB2
View attachment 28741


Looking forward to a smart solution.

Thanks / Jens

 

[JensBCN]

@JensBCN ... something like this:
Your 'Sheet1'
View attachment 28745
You could use [D2] kind of formula with 'Sheet2' and copy it down
View attachment 28746
... and maybe ";" need to be ","
ps. everyone likes sample files

Hello, thanks for your reply. I try in a moment if this works. I posted the Excel file.

 

[vletm]

@JensBCN
... with iferror
... something like this?

 

[JensBCN]

@JensBCN
... with iferror
... something like this?

wow ... how cool !!! you just made us *my gf's work" HAPPY