LOOKUP Function in Excel - In this video on the LOOKUP function in Excel, we'll go over how to use the LOOKUP function in Excel and also understand how it differs from the VLOOKUP function. A practical LOOKUP calculation example will be used to illustrate this.LOOKUP Function in Excel--------------------------------------------The LOOKUP function checks for a value in a range (which can be a single row or single column) and returns a corresponding LOOKUP from the same position of another range (single row or single column). The corresponding LOOKUP is a piece of information related to the value being searched.LOOKUP Excel Formula--------------------------------------------=lookup(lookup_value, lookup_vector, [result_vector])Arguments in LOOKUP Function:--------------------------------------------Lookup value: This is the value that you want to searchLookup vector: This is the row or column in which you wish to search the value. To achieve accurate results, it should be sorted alphabetically or in ascending order.Result vector: This is the row or column region from which you want the output to be returned. The returned output is in the same position as the "lookup value."------------------------------------------------------------------------------------------To know more about the LOOKUP Function, you can go to this link: https://www.wallstreetmojo.com/lookup-excel-function/ ------------------------------------------------------------------------------------------Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo