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

Solved/Closed
JensBCN Posts 2 Registration date Sunday March 20, 2016 Status Member Last seen March 20, 2016 - Mar 20, 2016 at 07:29 AM
JensBCN Posts 2 Registration date Sunday March 20, 2016 Status Member Last seen March 20, 2016 - Mar 20, 2016 at 02:04 PM
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

1 reply

JensBCN Posts 2 Registration date Sunday March 20, 2016 Status Member Last seen March 20, 2016
Mar 20, 2016 at 02:04 PM
here is the solution formula

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

works well = tested
0