bardown205
New Member
- Joined
- Mar 3, 2022
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I am new to excel and also new to the this forum.
I have a data set which I am trying to return values to another table.
The data I want returning needs to meet three different criteria, I have achieved this using a nested IF function (perhaps not the cleanest solution but it works, kind of).
My only issue is that prior to my desired value showing, it shows FALSE for all returns.
So;
FALSE, data1, data2, data3
My current formula is:
=TEXTJOIN(", ",TRUE,UNIQUE((IF(Sheet1!E:E=Info!A2,IF(Sheet1!G:G=D2,IF(Sheet1!S:S=Info!$G$1,Sheet1!K:K,""))))))
I have a data set which I am trying to return values to another table.
The data I want returning needs to meet three different criteria, I have achieved this using a nested IF function (perhaps not the cleanest solution but it works, kind of).
My only issue is that prior to my desired value showing, it shows FALSE for all returns.
So;
FALSE, data1, data2, data3
My current formula is:
=TEXTJOIN(", ",TRUE,UNIQUE((IF(Sheet1!E:E=Info!A2,IF(Sheet1!G:G=D2,IF(Sheet1!S:S=Info!$G$1,Sheet1!K:K,""))))))