Forum Discussion
help with functions
I need to keep track of running balance for purchase orders. My spreadsheet contains columns for: Vendor Purchase Order # Original AMT PO Funding CURRENT BALANCE PURCHASE DATE Time Auth...
I created sample data for your worksheet:
Fig. 1
If you used VLOOKUP(), it will only return the first instance it will find in the POLOG sheet, however if you used this formula:
=IFERROR(SUM(FILTER(POLOG!$I$4:$I$42,ISNUMBER(FIND($B3,POLOG!$B$4:$B$42)))),"")
it will find all the invoice/purchase request related to the PO and sum them all up.
Notice in Fig.1 above the column that says count, some POs have more than one expenditure entries which were all summed up to show the actual current balance of the respective POs.
cheers