I'll try this. Will this also be able to work on other sheets or
workbooks?
Here's the function I'm using in Excel, if it helps:
=IF($U$3="pe",'G4'!T352, IF($U$3="lo",('G4'!I352/'G4'!Q352)-1, IF
($U$3="hi",('G4'!I352/'G4'!P352)-1, IF($U$3="dl",('G4'!I352/'G4'!
L352)-1, IF($U$3="dh",('G4'!I352/'G4'!K352)-1, IF($U$3="vl",('G4'!
M352/100000000), IF($U$3="yt",('G4'!I352/'U:\Research\[G4K
010305.xls]G4'!J352)-1,IF($U$3="wk",('G4'!I352/'U:\Research\[G4K
013105.xls]G4'!J352)-1,'G4'!O352))))))))
This is what is in cell P3. Cell P4 would be the same formula except
it would reference row 353