Report

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 - Last answered 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 
Helpful
+0
moins plus
here is the solution formula

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

works well = tested
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!