Auto copy/paste data if criteria (same value in 2 cells) is met [Solved]

Ask a question JensBCN 2Posts Sunday March 20, 2016Registration date March 20, 2016 Last seen - Latest answer on Mar 20, 2016 02:04PM
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

Thanks / Jens
See more 
moins plus
here is the solution formula

=IFERROR(VLOOKUP(C2,'tab1'!B:F,5,FALSE),"- none -")

works well = tested
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!