Excel Formula help needed

Occasional Visitor

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 Q (Document 1, Sheet 1, Routes) I want to return the following;

 

Column B (Document 1, Sheet 1, Routes) is compared to Column B (Document 2, sheet 1, Comparison), if it matches then it returns to corresponding value from Column F (Document 2, Sheet 1, Comparison_

1 Reply

@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.