When cross matching data and extracting information from a particular column use Vlookup. However there are times when a Vlookup won’t do the job because it can only look to the right for the data to extract.
You will need to use an Index function together with a match.
If this sounds like the solution you need, book into our 2 hr training session Index – Match – Absolute course.
How to keep the same cell reference – Absolute Cell Referencing