yes, bob, exactly. i was trying the indirect between the &&'s

thanks

--


Gary


"Bob Phillips" wrote in message
...
Do you just mean

=INDIRECT("Rates.xls!"&A1&"_Tier1")*g58

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...

i'll simplify a little here. i have a separate workbook with rates and
some
named ranges. let's say one is Joe_Tier1 and another is Bob_Tier1.

then bob and joe have separate workbooks.

if i have their name in A1. how would i write a formula to replace "Joe"
wit the
value in A1?

Rates.xls!Joe_Tier1*G58




--


Gary