Forum Discussion
UsefulDragon
Dec 17, 2021Copper Contributor
Return value next to cell with multiple source arrays
Hi! This seems like a simple problem but I cant figure it out. So I have two tables with different values. I want to inspect the lower rows of the both tables (highlighted with grey) and find...
SergeiBaklan
Dec 18, 2021Diamond Contributor
As variant
=SUM( ($E$4:$N$4=C2)*$E$3:$N$3 + ($E$10:$N$10=C2)*$E$9:$N$9 )
assuming all numbers are different