Formula Help

[Todd Huttenstine]

="Customer Contract"&" for: "& 'Customer Records'!B3

Here is a formula above. Iinstead of refering to cell B3 on sheet 'Customer
Records' as the above formula does, I need for it to refer to cell A1 for
the cell number for ROW B. Example: Cell A1 contains the number 23. I
need for it to combine B and 23 so it refers to cell B23 on sheet 'Customer
Records'. The formula woud then be: ="Customer Contract"&" for: "&
'Customer Records'!B23. It will always refer to ROW B but just combine
whatever value is in cell A1 to get the exact address.

My problem is how to write the formula to do this combining.



Thanx in advance
Todd Huttenstine

 

[acw]

Todd

If I read this correctly then:

="Customer Contract"&" for: "& INDIRECT("'Customer
Records'!B"&A1)

Tony