Need Value of Concatenation not the Text

D

Darren

=CONCATENATE("='Products'!",C30) is what is in Cell H23
and it produces output of ='Products'!F2

The problem is, I don't want it to display ='Products'!F2
I want to display the value of F2 on worksheet Products

I use a combobox and the value goes into C30, so this is
dynamically driven. Is there a better way of going about
this other than using concatenate? Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the function in a cell that is created with CONCATENATE 2
Constructing Range Name calls with Concatenate 4
Excel does not accept text format! 0
Lookup against concatenated source value 4
Multiply with Vlookup value from another Worksheet 0
Searching the formula (not the value) for a text string 1
Different font characteristics in concatenated cell 0
sum cells to reach a specific value and return corresponding value 0

Top