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