Hi,
I need assistance in configuring my xlookup formula
Im stuck on figuring out a way on how I can reference cell B6 to look at 1 or 2 multiple text values
=XLOOKUP($J6&$C$1&L$5&$B6&"Text",'Consolidated Can'!$A$2:$A$495&'Consolidated Can'!$C$2:$C$495&'Consolidated Can'!$D$2:$D$495&'Consolidated Can'!$B$2:$B$495,'Consolidated Can'!$G$2:$G$495,0,0)
I need cell B6 to also look at another text value. Not sure if i need to insert an if statement in there?
Any help will be appreciated.
I need assistance in configuring my xlookup formula
Im stuck on figuring out a way on how I can reference cell B6 to look at 1 or 2 multiple text values
=XLOOKUP($J6&$C$1&L$5&$B6&"Text",'Consolidated Can'!$A$2:$A$495&'Consolidated Can'!$C$2:$C$495&'Consolidated Can'!$D$2:$D$495&'Consolidated Can'!$B$2:$B$495,'Consolidated Can'!$G$2:$G$495,0,0)
I need cell B6 to also look at another text value. Not sure if i need to insert an if statement in there?
Any help will be appreciated.