variable Cell references within formula

I have a number of Cell names LR0Cost, EX0Cost, IM0cost that hold %

formula might be

Please Login or Register  to view this content.

How can I get the "LR" and "EX" portion to be linked to another cell

Please Login or Register  to view this content.

Cheers

Matthew

hi Matthew,

Have a look at the Excel Help files for the "Indirect" function.

hth
Rob

Hi from the 'Naki!

i.e.
+a5*INDIRECT(B5&"0cost")
or
+a5*INDIRECT(B6&"0cost")

Does your formula actually start with a "+" or was that a typo? I know it works, but I'm just curious why you'd use it instead of the "="

cheers

Ex-Lotus user. It still works in Excel.