Relative Content

Tag Archive for if-statementvlookuptextjoinstale-if-error

Using TEXTJOIN and nested IFERROR/IF functions

I am trying to use TEXTJOIN together with IFERROR and IF to look up values from other tabs and combine (where relevant). The first tab might not have value to receive and in which case want to get from other tab, hence using IFERROR. However I seem to be getting the result plus a whole lot of FALSE responses.