Forum Discussion
Solved
Formula Help to retrieve a name from table and return a value
This might be complicated as I'm not extremely familiar with excel. I would like to create a formula that can find a name from the bottom table and depending on which section it is in (cleanup / setu...
In C25, confirmed with Ctrl+Shift+Enter to turn it into an array formula:
=SUMPRODUCT(($A$48:$A$61=C$24)*(IFERROR(FIND($B25,$B$48:$M$61),0)=1))
Fill to the right to F25, then fill down.
In C25, confirmed with Ctrl+Shift+Enter to turn it into an array formula:
=SUMPRODUCT(($A$48:$A$61=C$24)*(IFERROR(FIND($B25,$B$48:$M$61),0)=1))
Fill to the right to F25, then fill down.