Excel Formula help needed

[KarlosMigel]

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_

[#2]

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