Excel calculating multiple values using Vlookup

[RubenC]

Hello Guys,

Hope your good.
I need help calculating multiple values from two diferent sheets using vlookup.
This is for a loan system that we want to have for us to keep track of loan vs payments and also im working on mail merging this information and send it as an invoice on a later date.
For me to be able to do this i need to have this calculations on point.
Can i get some help ?
Thanks in advance !!

i will attach the documents in a sec.

thanks !

[rlmh06]

Try this:

=SUMIFS('[New Advances (1).xlsx]Sheet1'!$C:$C,'[New Advances (1).xlsx]Sheet1'!$B:$B,B3)-F3-G3-H3

[PaulM100]

Try:

Please Login or Register  to view this content.

If the criteria is not found by SUMPRODUCT will return 0, so an IF is necessary to not display the ones not found. Use the one bellow if you do not want negative values:

Please Login or Register  to view this content.