Lookup Data in Excel
There are several LOOKUP functions in Excel however the most popular by far is the VLOOKUP. Most people find it easier than the INDEX function combined with the MATCH Function. Even though the INDEX and MATCH function nested together is much more powerful.
Because the INDEX and MATCH function together don’t require the lookup value to be in the first column of the Lookup table.
The MATCH function notes the numerical location of a value (piece of data eg : invoice no. item description).
The INDEX function acts like a coordinate tool. Tell me how many rows to go down. Tell me how many columns to go across and it will return data from the intersecting point.
Now, just to blow your mind if those functions got you excited. Try the XLookup function.
If you are familiar with the VLOOKUP function you are going to love this one. If you have used the INDEX and MATCH function, you are going to love the XLOOKUP function.
It has a wildcard character feature and a way of searching from the bottom up as well as the standard top to bottom. It has the IFERROR functions built into it.
Best I loved nesting the XLOOKUP Function with another XLOOKUP Function, instead of having to do INDEX and MATCH.
What’s In An Intermediate Level of Excel?
The focus for an Excel Intermediate level courses is functions. Logical functions like IF. The IF function come with a family. IFERROR, IFNA, IFS.
Nesting functions is popular at this level of Excel and the IF function can be nested with functions that might make no sense if they acted alone like the AND, OR and NOT functions.
The VLOOKUP as mentioned before is the most popular and can be covered at either Level Intermediate or Advanced it will depend on the Training facility you choose.
Who should do and Excel course? Read more
When you book an Excel Course through AZ Solutions Pty Ltd, it doesn’t matter if you know how to create an IF Function or not because in my classes I will take you from basic formulas and functions making sure you have your structure correct and build from there.
My philosophy is everything is easy once you get shown how.
Analir Pisani the facilitator at AZ Solutions Pty Ltd will always make sure she has your attention before continuing with a concept. Ensuring you never miss a step.
What’s good about these courses is that they can be tailored to client job specific needs.
Visit this article which will give you an in-depth knowledge of the topics generally covered in an Intermediate Level Course of Microsoft Excel.
Visit this article on more details about the XLookup Function includes a YouTube video.