### Similar Threads:

1.Build excel formula using field values as text in the formula

Instead of writing the formula to add two cells as say, B4+B38 in Excel, I
want to build the formula using the contents on another cell, e.g.
I've tried B4+"B"&(TEXT(B13,0)).
The value of B13 is 38, therefore +"B"&(TEXT(B13,0)) equates to B38. That
works fine. But if I combine it with B4 as above, the result is #VALUE!
Any ideas on how I could get around this?

2.Build a formula from contents of other cells?

Greetings
I don't think it is possible to do the following:
cell A1 contains: =Sheet2!
cell A2 contains: G
cell A3 contains: 3
cell A4 contains: +A1+A2+A3
to produce the formula '=Sheet2!G3'
But is there another way to achieve this so that I can
regularly change many formulas by changing the contents of
one cell?
thanks
Dan

3.Can you build a formula in one cell with flexibility

I have a simple division equation in one cell. It calculates from two other
cells. The two cells may have to be moved down (not the entire row, just a
portion of row). But the cell with the calculation follows this shift. I
need for that calculation cell to be smart and after I shift the cells that
make up the calculation, I need for the original cells to still be part of
the calculation cell

4.build complex formulas using the dialogue box

In earlier versions of Excel, such as 97, you could create complex formulas
by using the formula dialogue box for help. There was always an insert
formula icon next to the criteria line currently being populated. This would
allow you to keep building complex formulas without having to know the
criteria for each formula. Why isn this possible with 2002/2003? I hope
they bring it back. Does anyone know of a work around for this?

5.named ranges in building excel formulas from a string

I have two ranges named PReq and QOutput.
I have this procedure:
Sub test_dependency()
Call dependency(Worksheets("PP"), [PReq], [QOutput], "testtitle")
End Sub
And I have:
Sub dependency(Result As Worksheet, Ratiorange As Range, Qrange As
Range, Title As String)
row_id = some array which results in a value
[Yearstart].value = 5
rowitem = 5
colitem = 5
z=10
Result.Cells(rowwriter, z).formula = "=vlookup(" & row_id(rowitem, 1)
& "," & Qrange.name & "," & z - [Yearstart].Value + 1 & ",false) *
index(" & Ratiorange.name & "," & rowitem & "," & colitem & ")"
I desperately want the formula to look like:
=vlookup(4,PReq,6,false)*index(QOutput,5,5)
I'll take
=vlookup(4,PReq!$b$5:$h$100,6,false)*index(QOutput!$b$5:$g$10,5,5)
but I get
=vlookup(4,=PReq!$b$5:$h$100,6,false)*index(=QOutput!$b$5:$g$10,5,5)
I've tried Qrange.name, .address, .value, .text anything. they all
dont' work. Then I tried to go through the Locals window and when I
clicked onto Qrange -> Cells -> Name, lo and behold, it was "QOutput".
So then I tried
?Qrange.cells.name in the immediate window and got a syntax error
same with:
?[Qrange].cells.name and ?Range("QRange").cells.name
Tell me your learning curve is as steep as mine because this should be
very obvious

6. building a formula

7. building a formula with non-US country setting

8. Building Excel Formula that Returns the Column of Last Cell with Data