lOoKuP

In offices / factories/schools we have a large number of data. And to find one name from the whole data become difficult .So to make our work easier a LOOKUP function is in built in excel. This function is performed in a row or column. In this we select a range from which we have want to find the name.

• The data below is of the employees with their residence and salary. As you can see the data is very big we can’t see the names below. So here is the quick and  easy way.

• By applying formula =LOOKUP (First Cell, whole range, the range of content we want in that cell).And then press enter. We not only apply this for office use but also in school for student’s fees or marks.

• This is how you apply it in all cells in a row.