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

Solved/Closed
JensBCN Posts 2 Registration date Sunday 20 March 2016 Status Member Last seen 20 March 2016 - 20 Mar 2016 à 07:29
JensBCN Posts 2 Registration date Sunday 20 March 2016 Status Member Last seen 20 March 2016 - 20 Mar 2016 à 14:04
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
Related:

1 response

JensBCN Posts 2 Registration date Sunday 20 March 2016 Status Member Last seen 20 March 2016
20 Mar 2016 à 14:04
here is the solution formula

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

works well = tested