Feb 19 2020 04:59 AM
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
Feb 19 2020 05:42 AM - edited Feb 19 2020 05:43 AM
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
Regards, Faraz Shaikh