SOLVED

Help: Source info from one tab to another tab

%3CLINGO-SUB%20id%3D%22lingo-sub-2227619%22%20slang%3D%22en-US%22%3EHelp%3A%20Source%20info%20from%20one%20tab%20to%20another%20tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2227619%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20you%20help%20me%20figure%20out%20how%20to%20bring%20source%20info%20from%20a%20tab%20to%20another%2C%20according%20to%20the%20company.%20I%20attached%20an%20excel%20work%20with%20sheet%20that%20should%20be%20very%20helpful.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20basics%3A%20I%20need%20the%20info%20from%20Column%20D%20in%20the%20%22Source%20Tab%22%20to%20populate%20in%20Column%20H%20of%20the%20%22Destination%20Tab%22%2C%20according%20to%20the%20correlating%20company%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thank%20you%20in%20advance%20for%20taking%20the%20time%20to%20read%20this%2C%20your%20help%20means%20much%20to%20me%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2227619%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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)
Solution

@NoraJJ 

In H2 on the Destination Tab:

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

Fill down.

 

S0228.png

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.