1. 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

2. 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.

3. [quote name='HansV' post='782263' date='29-Jun-2009 14:10']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.[/quote]

Hi Hans

Thanks for the explantion

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•