Microsoft Office Tutorials and References
In Depth Information
GET DATA FROM ANOTHER WORKSHEET BY USING INDIRECT
Solution: You need to specify the correct custom number format by using the
TEXT function. In Figure 34, the formula is =INDIRECT("’"&TEXT(A3,"mmm
d yyyy")&"’!B4") . This builds a reference such as ‘ Sep 1 2008’!B4 .
Figure 34. You use the TEXT function to convert the date to
text that looks like a date.
The second argument of the TEXT function coerces the date to match the style
of the worksheet name. If someone built a worksheet with a name such as
Sep-1, the formula would be:
If your worksheets are named 9-1, the formula would be:
If you are lucky enough that your worksheets are simply named 1, 2, 3, and so
on, you can use =INDIRECT(DAY(A3)&"!B4") , as shown in Figure 35.
Figure 35. In this case, TEXT can be replaced with DAY .