I have this array formula that all works as intended when value to be retrieved is in column ‘S’, however the value may be in column ‘T’, how do I tweak this formula to retrieve it when it is.
(When ‘S’ = value, ‘T’ will always = ”” and when ‘S’= ””, ‘T’ will always = value)
Please Login or Register to view this content.
Bookmarks