Help: Source info from one tab to another tab

Occasional Contributor

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

2 Replies
best response confirmed by NoraJJ (Occasional Contributor)


In H2 on the Destination Tab:

=IFERROR(VLOOKUP(G2,'Source Tab'!$C$2:$D$6,2,FALSE),"")

Fill down.



Hans! You've done it again, you are so great with this stuff and very helpful!! You just made the workday better! Thanks for your time and effort for me, a stranger, to understand Excel better. I learnt something today.