scenario:
file ABC.xls has the number 5 in A1 (a closed file)
file XYZ.xls has the number 10 in A1 (a closed file)

file choose.xls (an open file) has EITHER ABC or XYZ in cell A1 and ~some
formula in A2

i need a formula for cell A2 (choose.xls) that will display EITHER 5 or 10
in A2, depending on what is in cell A1 (EITHER ABC or XYZ)??

thanks


--
dh13134