In this tutorial you will learn how to use lookup function in excel. Lookup function is use to search data in work sheet of microsoft excel. It is very powerful feature of microsoft excel by which search of data is very easy in excel sheet.

You can type it like as following.

=LOOKUP(Value, Range of cell for search, Range of result)

This function is used for the data which is in sort form. You can use lookup function to finding the marks of student having any name like James.

use lookup function in excel example:-

Create a mark sheet of students and sort it by name. Sheet same as following.

sheet-for-lookup-function

You can find the marks of student name as Jill. You type in cell B14 a lookup function same like as following.

=LOOKUP(“Jill”,A2:A5,B2:B5)

use lookup function in excel

Result appear in B14 after when you press enter key same like as following work sheet of microsoft excel.

lookup-function-is-applied

If you want to search marks of Mark the use lookup function like as following.

=LOOKUP(“Jill”,A2:A5,B2:B5)

lookup-for-mark

After pressing the enter key result display in the selected cell of work sheet.

use lookup function in excel

You also can search the student which has Marks 328.25 by following use of lookup function in microsoft excel spread sheet.

=LOOKUP(328.25,B2:B5,A2:A5)

use lookup function in excel

Name of student appear in selected cell after pressing the enter key form keyboard and sheet become same as following sheet.

name-of-student-by-marks

You can find the name of student which has minimum marks in class. So for finding the student you need to use function like as following function.

=LOOKUP(MIN(B2:B5),B2:B5,A2:A5)

Here MIN(B2:B5) give the minimum marks which are 318.166666666667. Then lookup function search the name of student which is Jill. You use it like as following sheet of excel.

use lookup function in excel 2013

To show result press enter key like as following spread sheet of microsoft excel.

 name-of-student-having-min-marks

So at the end you has learned how to use lookup function in excel for finding the values of names.

Please follow and like us:

ali hiader

Leave a Reply

Your email address will not be published. Required fields are marked *