Finding the Max and Min value in an Alphanumeric Data

This post will guide you how to find the maximal and minimal value or string from an alphanumeric data list in excel. How do I retrieve or get the max or min string value based on alphabetic order from a string data in excel. For example, if you want to find the Maximal or minimal… read more »

How to Lookup the Value with Multiple Criteria

This post explains that how to lookup the value in a table or a range based on the multiple criteria in excel. This post will guide you how to search for a specified value with multiple criteria using INDEX and Match functions. And how to use Lookup function to lookup the value with multiple criteria…. read more »

Excel Lookup Function

This post will guide you how to use Excel LOOKUP function with syntax and examples in Microsoft excel. Description The Excel LOOKUP function will search a value in a vector or array. The LOOKUP function is a build-in function in Microsoft Excel and it is categorized as a Lookup and Reference Function. The LOOKUP function is available… read more »