Forum Discussion
Wilma_Lombaard_SAWR
Jun 05, 2022Copper Contributor
End Result of Formula
Good day, I do not know how how to use this forum and I don't know how to properly use formulas. But here goes. I have information in columns E And O & I that can be different depending on the l...
Wilma_Lombaard_SAWR
Jun 05, 2022Copper Contributor
Riny_van_Eekelen
SergeiBaklan
Jun 05, 2022Diamond Contributor
Or, if XLOOKUP is not available
=IFNA( $I3*INDEX($N$7:$N$26, MATCH($E3, $O$7:$O$26, 0 ) ), 0 )