Concatenate not linking to seperate tab, only shows formula in cell.

[Tony P]

Hi all,

I am trying to use the concatenate function to retrieve information from a cell on a separate tab but the cell I am typing in is only showing the formula, not the result.
I have changed the format of the cell as this was mentioned in previous threads as a possible reason but it hasn't solved the problem.

Sheet1 is called 'Overview' that is the firs image
Sheet 2 is called "Details' that is the 2nd image

The formula I have entered into D4 is =CONCATENATE("Details!"&D3&A4)
The result it comes back with is Details!i10 which is exactly where I want it to look to get the required information

I have also tried this with =CONCATENATE("'Details!'"&E12&B13) which has the additional apostrophes in '

 

[Fluff]

Hi & welcome to MrExcel.
You need to use indirect not concatenate like

=INDIRECT("Details!"&D3&A4)

 

[Tony P]

A

Hi & welcome to MrExcel.
You need to use indirect not concatenate like

=INDIRECT("Details!"&D3&A4)

asolutely perfect, thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

For future reference

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Concatenate formula not linking to separate tab
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.