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

Report
Posts
2
Registration date
Sunday March 20, 2016
Status
Member
Last seen
March 20, 2016
-
Posts
2
Registration date
Sunday March 20, 2016
Status
Member
Last seen
March 20, 2016
-
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

Posts
2
Registration date
Sunday March 20, 2016
Status
Member
Last seen
March 20, 2016

here is the solution formula

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

works well = tested

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!