Hi,

New member here; I did a search on the subject but it didn't seem to answer my question so here it goes.

I am using the "concatenate" function to combine text that is stored in three separate cells:

=CONCATENATE(Text!A1,Data!BC2,Text!A2)

where:

Text!A1 = VLOOKUP($B6,'C:\Users\gth802s\Dropbox\Habersham EMC Data Analysis\2009 Retrofits\[

Data!BC2 = Clark,Randall L

Text!A2 = -2009_usagereport.xls]Sheet1'!$C$22:$P$4000,4,FALSE)

with the result being:

VLOOKUP($B6,'C:\Users\gth802s\Dropbox\Habersham EMC Data Analysis\2009 Retrofits\[Clark,Randall L-2009_usagereport.xls]Sheet1'!$C$22:$P$4000,4,FALSE)

What I would like to do is to have the command evaluated directly in the cell so that the Vlookup function is executed and the cell displays the result directly. I tried putting an equal sign in front of the expression as follows:

="="&CONCATENATE(Text!A1,Data!BC2,Text!A2)

but this doesn't seem to help (I am guessing this is because Excel still sees it as text).

Any suggestions on how to get this to execute in the cell?

Thanks in advance,

-Fikret

<tbody>

</tbody>

New member here; I did a search on the subject but it didn't seem to answer my question so here it goes.

I am using the "concatenate" function to combine text that is stored in three separate cells:

=CONCATENATE(Text!A1,Data!BC2,Text!A2)

where:

Text!A1 = VLOOKUP($B6,'C:\Users\gth802s\Dropbox\Habersham EMC Data Analysis\2009 Retrofits\[

Data!BC2 = Clark,Randall L

Text!A2 = -2009_usagereport.xls]Sheet1'!$C$22:$P$4000,4,FALSE)

with the result being:

VLOOKUP($B6,'C:\Users\gth802s\Dropbox\Habersham EMC Data Analysis\2009 Retrofits\[Clark,Randall L-2009_usagereport.xls]Sheet1'!$C$22:$P$4000,4,FALSE)

What I would like to do is to have the command evaluated directly in the cell so that the Vlookup function is executed and the cell displays the result directly. I tried putting an equal sign in front of the expression as follows:

="="&CONCATENATE(Text!A1,Data!BC2,Text!A2)

but this doesn't seem to help (I am guessing this is because Excel still sees it as text).

Any suggestions on how to get this to execute in the cell?

Thanks in advance,

-Fikret

<tbody>

</tbody>

Last edited: