rusty on ms excel formulas, please help...

Copper Contributor

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

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