Used Concatenate To Create Formula But Cannot Get It To Do What I need

[TkdKidSnake]

Hi All,

I'm hoping that someone will be able to help me as I am at my wits end.

I have created a cell reference from the tab/sheet name as below:

In cell U5 is this
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

This retrieves number 1 for example

In cell V5 is this
=CONCATENATE("A",U5+3)
This creates the cell value A4

Using this cell number I want to pull the data from another sheet, the standard formula would look like the below which in itself is very simple however when I want to us the cell number created from cell V5 I am unable to find away to do it. V5 is a moving feast but would always be numeric + 3

Formula I would like is
='SCORING BY MONTH'!A4


Would really appreciate the help, i'm sure its very simple but I just can't see it.

Thanks

 

[Fluff]

Try
=INDIRECT("'SCORING BY MONTH'!"&V5)

 

[Rick Rothstein]

You need to use the INDIRECT function to reference a cell address that is text...

=INDIRECT("'SCORING BY MONTH'!"&V5)

 

[TkdKidSnake]

Try
=INDIRECT("'SCORING BY MONTH'!"&V5)

Now that is awesome, thank you very much indeed, works a treat.

 

[TkdKidSnake]

You need to use the INDIRECT function to reference a cell address that is text...

=INDIRECT("'SCORING BY MONTH'!"&V5)

Awesome, thank you very much indeed, works a treat.

 

[Fluff]

You're welcome & thanks for the feedback