Maybe if chris can help me out with this one again. Thanks again for the help yesterday, that formula worked excellent. I have the following formula now:
=IF(OR(A1={"V-Valve (AO)","X-Motor (VFD)"}),"AO",IF(OR(A1={"V-Valve (DO)","X-Motor (Start/Stop)"}),"DO",IF(OR(A1={"ZO-open","ZC-close","ZO/ZC-open/close"}),"DI",IF(A1=("ZT-(Transducer)"),"DO",""))))
I want to replace "A1" in the formula above with: =INDIRECT("'Instrument Tags'!"&CHAR(SUBSTITUTE(MOD(ROW(),7),0,7)+76)&ROUNDUP((ROW()/7),0)+2).
Replacing it is no problem. The problem is that excel will not accept it, probably because it has more than 7 functions imbedded or maybe too many characters. Are you able to help me out any? Hoping that this one will not exhaust you as much as the last problem! Ha Ha.
P.S. I was able to figure out you're logic out, with the last problem that is, thanks.
=IF(OR(A1={"V-Valve (AO)","X-Motor (VFD)"}),"AO",IF(OR(A1={"V-Valve (DO)","X-Motor (Start/Stop)"}),"DO",IF(OR(A1={"ZO-open","ZC-close","ZO/ZC-open/close"}),"DI",IF(A1=("ZT-(Transducer)"),"DO",""))))
I want to replace "A1" in the formula above with: =INDIRECT("'Instrument Tags'!"&CHAR(SUBSTITUTE(MOD(ROW(),7),0,7)+76)&ROUNDUP((ROW()/7),0)+2).
Replacing it is no problem. The problem is that excel will not accept it, probably because it has more than 7 functions imbedded or maybe too many characters. Are you able to help me out any? Hoping that this one will not exhaust you as much as the last problem! Ha Ha.
P.S. I was able to figure out you're logic out, with the last problem that is, thanks.