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.
You can find the marks of student name as Jill. You type in cell B14 a lookup function same like as following.
Result appear in B14 after when you press enter key same like as following work sheet of microsoft excel.
If you want to search marks of Mark the use lookup function like as following.
After pressing the enter key result display in the selected cell of work sheet.
You also can search the student which has Marks 328.25 by following use of lookup function in microsoft excel spread sheet.
Name of student appear in selected cell after pressing the enter key form keyboard and sheet become same as following sheet.
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.
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.
To show result press enter key like as following spread sheet of microsoft excel.
So at the end you has learned how to use lookup function in excel for finding the values of names.