Forum Discussion
Solved
Populate cell from horizontal assignment
I have this - Sheet2: The 'X' marks indicate which category the product belongs to (either Category name1, Category Name2, or Category Name3). Sheet1: In Column B, I want to calculate and pop...
=IFERROR(FILTER('Sheet2'!$B$1:$D$1, INDEX('Sheet2'!$B$2:$D$1000, XMATCH($A3, 'Sheet2'!$A$2:$A$1000), 0)="X"), "")
=IFERROR(FILTER('Sheet2'!$B$1:$D$1, INDEX('Sheet2'!$B$2:$D$1000, XMATCH($A3, 'Sheet2'!$A$2:$A$1000), 0)="X"), "")
This is exactly what is applicable in my case.