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. What you can do to make your Vlookup function in Microsoft Excel so much easier to read is to use Range Names. Instead of selecting the Sheet and then the Master Data use a Range Name. You can also use Range Names in Data Validation Lists.
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.
If you are still struggling AZ Solutions Pty Ltd provides Customized Face to Face training in Sydney – Australia.
How to keep the same cell reference – Absolute Cell Referencing