PDA

View Full Version : how to replace part of r1c1 formula with cell value?



felpslima
09-16-2010, 07:15 AM
Hello!

I'm having a lot of trouble when trying to find and replace a certain part of a formula written in column B with the cell values in column A.

In column B I have written the following code "=TWSVR|CMA!'0012XXXX;1'"
In column A, I have several names.

What I need to do is to is to find a way to put every A value into its B equivalent row within this formula.

Can anymone help me?

Thanks!

Bob Phillips
09-16-2010, 07:59 AM
Try

=INDIRECT("TWSVR|CMA!'" & TEXT(A1,"0000") & "XXXX;1")

felpslima
09-16-2010, 08:47 AM
Thanks for your reply, but it didn't work...

Bob Phillips
09-16-2010, 11:10 AM
Then we need clearer details on what you want, I just took a punt.

felpslima
09-17-2010, 10:33 AM
Can I upload a sample sheet then?


Then we need clearer details on what you want, I just took a punt.

Bob Phillips
09-17-2010, 01:09 PM
Yes you can, select the 'Go Advanced' button below the message box, and then there is a 'Manage Attachments' button to do this.