"Find out " Find the name of student whose admission number is 8267

Question

The following details are given

Find out 

• Find the name of student whose admission number is 8267
• Look up value 8136 and locate the fee paid status by using VLOOKUP 
• Look up the name of student against admission number 8124 
• Ad. No. of student who paid fee Rs. 580

Answer 1

Procedure: 

Step 1 – Open LibreOffice Calc worksheet Application → Office → LibreOffice Calc. 

Step 2 – Enter the details in the given cells

Step 3 – Enter the given details and formula in the following cells

	A
8	Name of student Ad.No.8267
9	Fee paid status of Ad No.8136
10	Name of student Ad. No.8124
11	Ad.No. of student, paid Rs.580

 

	B
8	= LOOKUP(8267,A2:A7,B2:B7)
9	= VLOOKUP(8136,A2:C7,3,0)
10	= LOOKUP(8124,A2:A7,B2:B7)
11	= VLOOKUP (8370,A2:C7,3,0)

Output: