Mar 22 2021 06:47 AM
Good Day
Could you help me figure out how to bring source info from a tab to another, according to the company. I attached an excel work with sheet that should be very helpful.
The basics: I need the info from Column D in the "Source Tab" to populate in Column H of the "Destination Tab", according to the correlating company number.
I thank you in advance for taking the time to read this, your help means much to me :)
Mar 22 2021 06:58 AM
SolutionIn H2 on the Destination Tab:
=IFERROR(VLOOKUP(G2,'Source Tab'!$C$2:$D$6,2,FALSE),"")
Fill down.
Mar 22 2021 07:38 AM
Mar 22 2021 06:58 AM
SolutionIn H2 on the Destination Tab:
=IFERROR(VLOOKUP(G2,'Source Tab'!$C$2:$D$6,2,FALSE),"")
Fill down.