Welcome to Excel Jet Consult blog post. In this short video tutorial, we will to learn how to use the VLOOKUP function approximate match. Enjoy
Continue readingDynamic Advanced Conditional Formatting With Data Validation
Welcome to Excel Jet Consult blog post. In this short video tutorial, we will learn how to dynamically apply conditional formatting to our data with List Data Validation drop-down. Enjoy the video
Continue readingArray Formula: SUM Contiguous & Non-Contiguous Values With VLOOKUP
Welcome to Excel Jet Consult. In this video tutorial, we will learn how to sum contiguous and non_contiguous values using VLOOKUP & SUM functions with array formula. Enjoy the video
Continue reading