Advanced Excel Course Lookup and Reference Function Notes Set 01

Official Study Materials for Computer Science

Access comprehensive study materials and useful resources for MS Office using the Advanced Excel Course Lookup and Reference Function Notes Set 01. Designed to align with the 2026-27 academic guidelines, these advanced resources help Computer Science students reinforce core concepts beyond standard textbooks.

Advanced Resources for Computer Science

Access the complete useful resource PDF for Computer Science below. Regular practice with these targeted academic notes builds familiarity with complex topics and helps secure higher marks in final school evaluations.

The lookup functions VLOOKUP and HLOOKUP are explained with an employee table and a salesman sales table, followed by MATCH and the INDEX with MATCH combination used to fetch a person's address from a list.

VLOOKUP

VLOOKUP searches for a value in the first column of a table and returns a value from the stated column of the same row. The arguments are lookup value, table range, column number and 0 (exact match).

ID NoFirst NameLast NameDivisionMonthly Salary
AB1234MohdHaiderCEO80000
BC42345HarperWilliamsMarketing23000
CD13456DennisRitchieAccounting26000
DE4567ThomasSmithSales21000
EF5678BrownJonesResearch30000
FG6789JacksonDavisAccounting26000
GH78910AlamZaidiCA32000
HI891011MillerTaylorSales21000
IJ9101112AnkitSinghResearch30000
KL111213JonesAndersonSales21000

A second block with the headings ID No, First Name, Last Name, Division and Monthly Salary shows the ID numbers HI891011, BC42345, GH78910, KL111213 and EF5678 in column A. The other four columns are filled with VLOOKUP formulas that use column numbers 2, 3, 4 and 5.

=VLOOKUP(A15,A1:E11,2,0)   First Name
=VLOOKUP(A15,A1:E11,3,0)   Last Name
=VLOOKUP(A15,A1:E11,4,0)   Division
=VLOOKUP(A15,A1:E11,5,0)   Monthly Salary

HLOOKUP

HLOOKUP searches for a value in the first row of a table and returns a value from the stated row of the same column. The table has the names of nine salesmen across the top (RAVI, RAJU, AMIT, VINOD, MAYANK, DENNIS, ROHIT, SHUBHAM, MANISH) and the four months JAN, FEB, MAR and APR down the first column.

NAME OF SALESMANRAVIRAJUAMITVINODMAYANKDENNISROHITSHUBHAMMANISH
JAN308495466255440314399283493
FEB351479461276357404290272353
MAR456422279348305330485492464
APR392439489492475322299319410
=HLOOKUP(A10,A2:J6,2,0)   MANISH, JAN
=HLOOKUP(A10,A2:J6,3,0)   MANISH, FEB
=HLOOKUP(A10,A2:J6,4,0)   MANISH, MAR
=HLOOKUP(A10,A2:J6,5,0)   MANISH, APR
=HLOOKUP("DENNIS",A2:J6,2,0)   DENNIS, JAN

The row numbers 2, 3, 4 and 5 are counted from the first row of the table range (the row with the salesmen names).

MATCH

=MATCH(A8,A2:A10,0)

MATCH returns the position of a value in a list. The list A2:A10 holds the names Ram, Mohan, Ram, Bablu, Ram, Teena, Reena, Mohan and Pinki; the value in A8 (Reena) is the 7th item of the list, so the result is 7.

INDEX with MATCH

=INDEX(A3:D11,MATCH(F5,B3:B11,0),4)

INDEX returns the value found at a given row and column of a range. MATCH finds the row number of the name and 4 is the column number of Address. The sheet has the columns ID, Name, Age and Address; typing the name Mohan in F5 gives its address in G5.

IDNameAgeAddress
3429Mohan24Agra
2826Rohan22Mathura
1833Shyam18Aligarh
5207Geeta20Agra
6040Savita19Mathura
6713Mohit21Aligarh
374Madhav18Agra
2467Shalini22Mathura
1383Shruti23Aligarh

Result for Mohan: Agra.

CBSE Computer Science Study Material: MS Office

Quick Revision Material for MS Office

Explore essential learning tools for Computer Science MS Office. This curated collection features in-depth notes and targeted practice questions built around the active 2026 curriculum to streamline your daily revision.

Expert Notes and Solved Exam Questions

Built using official NCERT guidelines for Computer Science, these materials provide reliable academic support. Integrating past examination questions and step-by-step solutions helps students understand official CBSE grading criteria.

Additional Study Resources for

Maximize your grade potential by utilizing Computer Science practice papers in tandem with these structured notes. All printable assignments and interactive mock tests on our platform are updated for the 2026 session and available free of charge.

FAQs

Where can I find the most advanced study material for [current-page:node:field_board] [current-page:node:field_class] Computer Science for 2026-27?

The latest 2026-27 advanced study resources for Computer Science are available for free on StudiesToday.com which includes NCERT Exemplars, high-order thinking skills (HOTS) questions, and deep-dive concept summaries.

What does the 2026-27 Computer Science study package for [current-page:node:field_class] include?

Our exhaustive Computer Science package includes chapter wise revision notes, solved practice sheets, important formulas and Concept Maps to help in better understanding of all topics.

Is this study material enough for both [current-page:node:field_board] exams and competitive tests?

Yes. For , our resources have been developed to help you get better marks in school exams and also build fundamental strength needed for entrance tests including Competency Based learning.

How should [current-page:node:field_class] students use this Computer Science material for maximum marks?

in , students should use Active Recall method, read the concept summary, then solve the Important Questions section without looking at the answers and then check your answers.

Can I download [current-page:node:field_class] Computer Science study notes in PDF for offline use?

All Computer Science study materials are provided in mobile-friendly PDF. You can download and save them on your device.

Are the [current-page:node:field_class] Computer Science resources updated for the latest NEP guidelines?

Yes, our team has ensured that all Computer Science materials for are strictly aligned with the National Education Policy (NEP) 2020 and the latest 2026-27 syllabus.