Hi!

You can't "build" a formula like that.

You could do something like this:

A1 = Data!
B1 = text entry C44
B2 = text entry K44
C1 = D
D1= formula =""

=IF(INDIRECT(A1&B1)=C1,INDIRECT(A1&B2),D1)

Which evaluates to:

=IF(Data!C44="D",Data!K44,"")

Biff

"Bill Elerding" wrote in message
...
I have concatenated a number of cells to make a formula that I will update
data on a weekly basis. Unfortunately, the formula is in text currently,
as
noted below:

'=CONCATENATE(Q5,R5,S5,V5,Q5,P5,N5,W5,N5,O5,T5)

When I try to replace the ' it does not find it. I presume this is
because it is currently text. Formating the column as either General or
Number does not seem to work. Conversely, if I enter the cells and back
space over the ' , it works fine.

And this is what it looks like when I copy it over into it's destination
cell before deleting the ' :
=if(Data!c44="D",Data!k44,"")

Any thoughts or macro's I can try to have a functioning formula?

THANKS!
--
William Elerding