Formula References

[Todd Huttenstine]

Hey guys I am really having a hard time here.

On a sheet named Template, I have a number in cell K10. (This number is
currently 7 but can change). Ive got a sheet called Customer Records and
the values I need to reference are in ROW B on that sheet, therefore I need
to create a formula that will create yet another formula that will pull
values from ROW B in cell 7 off of sheet Customer Records. The formula
would be ='Customer Records'!B7. I need for this formula to be inserted in
cell A12 on the current sheet called Template.


Thanx in advance

Todd

 

[Todd Huttenstine]

But I need for it to say 'Customer Records'!B7. Both those formulas you
gave me gave me the correct answer but I need to somehow get the cell to
display the formula 'Customer Records'!B7. Does this make sense? Its kind
of confusing.


thanx

 

[J.E. McGimpsey]

Well, I must be confused. Can you not then use

="='Customer Records'!B" & K10

If I'm bollixing it all up (and I'm relatively certain I am),
perhaps David McRitchie's GetFormula function is more what you're
looking for...

http://www.mvps.org/dmcritchie/excel/formula.htm#getformula

 

[Arvi Laanemets]

Hi

Another way:
=OFFSET('Customer Records'!B1,Template!K10-1,0)


Arvi Laanemets