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.


=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

Learn MS Excel

Ask Questions

Ask Question