Forum Discussion
Solved
Formula to either pull multiple values with an Hlookup or a substitute formula instead of an Hlookup
Hello everyone, I am trying to either update my hlookup, or come up with a different formula when pulling values. My file includes a tab that has all my general ledger accounts in one row and...
=SUMPRODUCT(('Daily Updates'!$AG$5:$EG$5=A23)*'Daily Updates'!$AG$7:$EG$7)You can try the SUMPRODUCT formula.
=SUMPRODUCT(('Daily Updates'!$AG$5:$EG$5=A23)*'Daily Updates'!$AG$7:$EG$7)You can try the SUMPRODUCT formula.
Thank you so much! That function is exactly what I needed.