I’ll cover everything there is to know about it, and then show you useful and practical VLOOKUP examples. This is going to be a massive VLOOKUP tutorial (by my standards). Now that we know how important this Excel function is, it makes sense to ace it completely to be able to proudly say – “I know a thing or two in Excel”. I have been a part of the panel interviews where as soon as the candidate mentioned Excel as his area of expertise, the first thing asked was – you got it – the VLOOKUP function. If you don’t, you better not list Excel as one of your strong areas in your resume. You know something in Excel if you know how to use the VLOOKUP function. Using VLOOKUP Function in Excel – Video.Example 10 – Handling Errors while Using the VLOOKUP Function. Example 9 – Using VLOOKUP with Multiple Criteria.Example 8 – Doing a Case Sensitive Lookup.Example 7 – VLOOKUP Returning an Error Despite a Match in Lookup Value.Example 6 – Partial Lookup using Wildcard Characters and VLOOKUP.
0 Comments
Leave a Reply. |