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 search
Lookup 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=1
LinkedIn ► https://www.linkedin.com/company/wallstreetmojo/mycompany/
Facebook ► https://www.facebook.com/wallstreetmojo
Instagram ► https://www.instagram.com/wallstreetmojoofficial/
Twitter ► https://twitter.com/wallstreetmojo