LinkBack URL
About LinkBacks
dw7 
change name of TAB SI to i.e. SX, and try this in A1 and copy down
Logical_test Required
=IF(M!A1<>0,M!A1,IF(INDIRECT("E!A"&D1)<>0,INDIRECT("E!A"&D1),IF(INDIRECT("S!a"&F1)<>0,INDIRECT("S!A"&F1),INDIRECT("SX!A"&H1))))
change name of TAB SI to i.e. SX, and try this in A1 and copy down
Logical_test Required=IF(M!A1<>0,M!A1,IF(INDIRECT("E!A"&D1)<>0,INDIRECT("E!A"&D1),IF(INDIRECT("S!a"&F1)<>0,INDIRECT("S!A"&F1),INDIRECT("SX!A"&H1))))
Last edited by sandy666; 03-03-2015 at 09:07 PM. Reason: changed SI to SX
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks