Hi,
I created dynamic consolidated list using formulas listed in title.
When lists contain numbers everything is fine, but when I put text #VALUE! error occur only in 3rd list.
Hope I wrote clearly. If not everything is nice shown in attached excel file.
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks