Use Cell Value in Refernce Link

[Sameem]

Hi,

Is it possible to use the values from a cell in a link within excel? As an example:

Cell A1 has value: XYZ_2010

Cell A2 contains a reference link such as: =C:\Files\[XYZ_2010.xls]Sheet1'!B2

Would it be possible to link the XYZ_2010 portion of Cell A2 to Cell A1?

Thank you so much for your help!

[ConneXionLost]

Use the INDIRECT function following this format:

Please Login or Register  to view this content.

For your example, it would look something like this:

Please Login or Register  to view this content.

Cheers,