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

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

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