LOOKUP Function
The LOOKUP function looks for specific information from a list and returns a related/corresponding item from the second range of cells mentioned in the function.
Formula:
=LOOKUP(Item to lookup, Range to look in, Range to pick from)
Video Tutorial:
Let us look for an item in a range, using the LOOKUP function, with the help of the below video
