ASSIGNMENT – 29 — ANSWER KEY

Use of Formula – HLOOKUP

TABLE 1 – Monthly Sales

MONTH	JANUARY	FEBRUARY	MARCH	APRIL	MAY	JUNE
SALES	325	280	450	520	675	740

Q.1 — Sales of April

Formula:

=HLOOKUP("APRIL",A1:G2,2,FALSE)

Answer: 520

Q.2 — Sales of June

Formula:

=HLOOKUP("JUNE",A1:G2,2,FALSE)

Answer: 740

TABLE 2 – Student Marks

NAME	Aarav	Riya	Karan	Neha	Mohit	Simran
ENGLISH	78	85	72	91	64	88
MATHS	82	76	89	95	70	84
SCIENCE	75	90	81	87	68	92

Q.3 — English Marks of Neha

Formula:

=HLOOKUP("Neha",A1:G4,2,FALSE)

Answer: 91

Q.4 — Maths Marks of Karan

Formula:

=HLOOKUP("Karan",A1:G4,3,FALSE)

Answer: 89

Q.5 — Science Marks of Simran

Formula:

=HLOOKUP("Simran",A1:G4,4,FALSE)

Answer: 92

Q.6 — English Marks of Aarav

Formula:

=HLOOKUP("Aarav",A1:G4,2,FALSE)

Answer: 78

TABLE 3 – Employee Sales

EMP ID	EMP1001	EMP1002	EMP1003	EMP1004	EMP1005
SALES 1	65	48	72	85	91
SALES 2	54	76	68	92	80
SALES 3	70	83	75	88	95
SALES 4	62	79	81	96	87

Q.7 — Sales 4 of EMP1004

Formula:

=HLOOKUP("EMP1004",A1:F5,5,FALSE)

Answer: 96

Q.8 — Sales 2 of EMP1002

Formula:

=HLOOKUP("EMP1002",A1:F5,3,FALSE)

Answer: 76

TABLE 4 – Temperature & City

TEMPERATURE (°C)	22	28	34	39	45
CITY	Delhi	Jaipur	Mumbai	Pune	Bengaluru

Q.9 — City at 39°C

Formula:

=HLOOKUP(39,A1:F2,2,FALSE)

Answer: Pune

Q.10 — City at 45°C

Formula:

=HLOOKUP(45,A1:F2,2,FALSE)

Answer: Bengaluru

Final Answer Summary

Q.	Question	Answer
Q.1	April Sales	520
Q.2	June Sales	740
Q.3	Neha – English	91
Q.4	Karan – Maths	89
Q.5	Simran – Science	92
Q.6	Aarav – English	78
Q.7	EMP1004 – Sales 4	96
Q.8	EMP1002 – Sales 2	76
Q.9	39°C City	Pune
Q.10	45°C City	Bengaluru

⭐ HLOOKUP Row Number Trick

इस assignment में students को यह जरूर याद करवाएँ:

Table 2:

Row No.	Data
1	NAME
2	ENGLISH
3	MATHS
4	SCIENCE

इसलिए:

English → 2

Maths → 3

Science → 4

Table 3:

Row No.	Data
1	EMP ID
2	SALES 1
3	SALES 2
4	SALES 3
5	SALES 4

इसलिए:

Sales 1 → 2

Sales 2 → 3

Sales 3 → 4

Sales 4 → 5

यही row_index_num HLOOKUP में सबसे important part है.