Forum Discussion
KarlosMigel
Aug 08, 2022Copper Contributor
Excel Formula help needed
Morning, Can someone help with a formula for the follow please? How to I compare two column for different documents to return a value from a different column if it matches. So, In Column ...
Riny_van_Eekelen
Aug 08, 2022Platinum Contributor
KarlosMigel Since you tagged your question with Office365, XLOOKUP is the function you would want to use. Difficult, though, write a formula based on the textual description of what you need. Better to share a link to your file (remove any confidential information first) via Onedrive.