ASSIGNMENT – 9

LOOKUP Function

LOOKUP Function Syntax

=LOOKUP(lookup_value, lookup_vector, [result_vector])

Note: LOOKUP works correctly when the lookup vector is sorted in ascending order. For this assignment, students should understand the lookup vector and result vector clearly.

Table 1 – Employee Details

Employee ID Last Name First Name
120145 Sharma Amit
235078 Verma Neha
348216 Singh Rahul
451092 Kapoor Priya
562340 Mehta Rohan
673125 Gupta Anjali
784236 Khan Arjun
895147 Joshi Pooja
906258 Malhotra Vivek
117369 Saini Kiran
228470 Bansal Mohit
339581 Yadav Simran

Table 2 – Employee Salary

Employee ID Pay First Name Last Name
784236 ₹92,500    
451092 ₹1,28,600    
117369 ₹1,45,750    
235078 ₹88,900    
562340 ₹1,16,450    
339581 ₹76,800    
906258 ₹1,32,250    
348216 ₹97,500    
673125 ₹1,54,300    
120145 ₹1,10,750    
895147 ₹82,600    
228470 ₹1,25,900    

Questions

Q.1 LOOKUP – First Name

Using the LOOKUP function, find the First Name of the employee whose Employee ID is 784236.

Q.2 LOOKUP – Last Name

Using the LOOKUP function, find the Last Name of the employee whose Employee ID is 451092.

Q.3 Employee ID 117369

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 117369.

Q.4 Employee ID 562340

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 562340.

Q.5 Employee ID 673125

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 673125.

Q.6 Employee ID 906258

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 906258.

Q.7 Employee ID 339581

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 339581.

Q.8 Employee ID 228470

Using the LOOKUP function, find:

  1. First Name

  2. Last Name

of Employee ID 228470.

Q.9 LOOKUP – Employee ID & Pay

Using the LOOKUP function, find the following details of RAHUL:

  1. Employee ID

  2. Pay

Q.10 LOOKUP – Employee ID & Pay

Using the LOOKUP function, find the following details of POOJA:

  1. Employee ID

  2. Pay

LOOKUP Formula Practice

Find First Name by Employee ID

=LOOKUP(784236,A2:A13,C2:C13)

Find Last Name by Employee ID

=LOOKUP(451092,A2:A13,B2:B13)

Find Employee ID by First Name

=LOOKUP("RAHUL",C2:C13,A2:A13)

Find Pay by First Name

For the salary table, after filling the First Name and Last Name columns using LOOKUP:

=LOOKUP("RAHUL",C2:C13,B2:B13)

Formulas to Practice

LOOKUP with Employee ID → First Name

LOOKUP with Employee ID → Last Name

LOOKUP with First Name → Employee ID

LOOKUP with First Name → Pay

PreviousNext