EXCEL: Reference Functions

  1. The OFFSET is a powerful function in excel that returns a cell or range of cells that is specified by 5 inputs: reference or starting point, row offset, column offset, optional height in rows, optional width in columns.

=OFFSET(reference, rows, columns, [height],[width])

To get the latest value,

=OFFSET(A1, 3, 1, 1, 1)

2. The INDIRECT function will convert a text string into a valid reference. We can use & operator to create valid strings.

=INDIRECT(A9&”!G6"), A9 can be any text value -“California”

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Pallavi Mirajkar Dantkale
Pallavi Mirajkar Dantkale

Written by Pallavi Mirajkar Dantkale

QA Engineer / Data Analyst — Highly committed to Quality Assurance and data analysis, advocate for quality and add the right value to the organization.

No responses yet

Write a response