Indirect

Topic

New Reply

Hi

Would someone enlighten me on what does the ‘ in this formula represent?

=INDIRECT(“‘”&$A2&”‘!”&B$1)

the formula return the value in B1 of both Sheet2 and Sheet3 on Sheet1, B2

Reply | Quote

Replies

Let’s say that A2 contains the text January Sales, and that B1 contains the text K37.
The formula then evaluates to
=INDIRECT(“‘January Sales’!K37”)
which is equivalent to
=’January Sales’!K37
This returns the value of cell K37 on the sheet named January Sales.
The single quotes (apostrophes) are used around the sheet name; they are required if the sheet name contains spaces or unusual characters. If the sheet name is a single word, the single quotes aren’t required but they won’t hurt either.

Reply | Quote

Let’s say that A2 contains the text January Sales, and that B1 contains the text K37.
The formula then evaluates to
=INDIRECT(“‘January Sales’!K37”)
which is equivalent to
=’January Sales’!K37
This returns the value of cell K37 on the sheet named January Sales.
The single quotes (apostrophes) are used around the sheet name; they are required if the sheet name contains spaces or unusual characters. If the sheet name is a single word, the single quotes aren’t required but they won’t hurt either.

Hi Hans

Thanks for the explantion

Reply | Quote