Home

rusty on ms excel formulas, please help...

%3CLINGO-SUB%20id%3D%22lingo-sub-1181912%22%20slang%3D%22en-US%22%3Erusty%20on%20ms%20excel%20formulas%2C%20please%20help...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181912%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%20i%20am%20very%20rusty%20on%20ms%20excel%2C%20please%20help...%3C%2FP%3E%3CP%3EI%20have%20two%20worksheets%20A%2BB%2C%20I%20need%20to%20pull%20in%20data%20from%20sheet%20A%20to%20sheet%20B%2C%20sheet%20A%2BB%20both%20have%20matching%20records%2C%20company%20name%20for%20example%20that%20can%20link%20the%20sheets.%3CBR%20%2F%3Eso%20i%20need%20to%20pull%20in%20data%20from%20column%20C%20in%20sheet%20A%2C%20to%20say%20column%20L%20in%20sheet%20B.%3CBR%20%2F%3Ewhat%20would%20be%20formula%3F%3CBR%20%2F%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1181912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1181995%22%20slang%3D%22en-US%22%3ERe%3A%20rusty%20on%20ms%20excel%20formulas%2C%20please%20help...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1181995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F563126%22%20target%3D%22_blank%22%3E%40saj1011%3C%2FA%3E%2C%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUse%20XLOOKUP%20if%20your%20version%20of%20Excel%20supports%20that%20or%20else%20use%20VLOOKUP%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20videos%20on%20both%20the%20content%20and%20you%20also%20refer%20to%20the%20Microsoft%20site.%3C%2FP%3E%3CP%3E%3CSTRONG%3E1-XLOOKUP%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fxlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F-889FE5zTJ0%3Ft%3D126%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2F-889FE5zTJ0%3Ft%3D126%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E2-VLOOKUP%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fugg-NCNscUI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2Fugg-NCNscUI%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ERegards%2C%20Faraz%20Shaikh%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

hello, i am very rusty on ms excel, please help...

I have two worksheets A+B, I need to pull in data from sheet A to sheet B, sheet A+B both have matching records, company name for example that can link the sheets.
so i need to pull in data from column C in sheet A, to say column L in sheet B.
what would be formula?
thanks

1 Reply
Highlighted

Hi @saj1011

 

Use XLOOKUP if your version of Excel supports that or else use VLOOKUP

 

I have videos on both the content and you also refer to the Microsoft site.

1-XLOOKUP

https://support.office.com/en-us/article/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

https://youtu.be/-889FE5zTJ0?t=126

 

2-VLOOKUP

https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1

https://youtu.be/ugg-NCNscUI

 

Regards, Faraz Shaikh

Related Conversations
Finding a text value
saneri in Excel on
2 Replies
Excel
GSankar2312 in Excel on
0 Replies
Analizar varias tabas
William87 in Excel on
0 Replies
Making drop down menu represent an item & cost
mark_bates in Excel on
0 Replies
Excel
Chris246 in Excel on
2 Replies