Lesson Category: Vlookup

Video Transcript In this video, I’m going to explain how to use VLOOKUP and XLOOKUP for dynamic array formulas. So in this example, we have…

Companion File: Alternative Lookup Formulas.xlsx | sheet: HLOOKUP Video Transcript So in this video, we’re going to look at the HLOOKUP function, which is very similar…

Companion File: Advanced Lookup Formulas.xlsx | sheet: Convert Dates Video Transcript All right, so in this video we’re going to look at how to use the…

Companion File: Advanced Lookup Formulas.xlsx | sheet: Convert Dates The TRUNC function can also be used instead of ROUNDDOWN. Here is an article about grouping times…

Companion File: Advanced Lookup Formulas.xlsx | sheet: Lookup Dates Video Transcript Alright, in this video we’re going to look at how to do LOOKUPs with…

Companion File: Lookup Formulas with Excel Tables.xlsx | sheet: VLOOKUP Tables Video Transcript Alright in this video I just want to show a quick tip for…

Companion File: Lookup Formulas with Excel Tables.xlsx | sheet: VLOOKUP Tables Video Transcript Alright, so in this video we’re going to look at how write our…

Companion File: INDEX MATCH Examples.xlsx | sheet: Writing INDEX Match Video Transcript Alright, so in this video I’m going to explain how to write the index…

Companion File: INDEX MATCH Examples.xlsx | sheet: INDEX MATCH Vs VLOOKUP Video Transcript Alright, in this video we’re going to look at one of the major…

Here is a link to the article and video I mentioned on how to add a more permanent drop-down arrow to your cells that contain drop-down lists.…