=IF(ISNA(VLOOKUP(A3,'Sheet 1'!A$3:A$23,2,FALSE)),"",VLOOKUP(A3,'Sheet 1'!A$3:A$23,2,FALSE))
Total Sheet Sheet 1 Payment
Vendor listing Amount Vendor Amount
AACS Canon 40.00
ABF Gentry 300.00
Canon Key 25.00
Gentry
Key
=IF(ISNA(VLOOKUP(A3,'Sheet 1'!A$3:A$23,2,FALSE)),"")
My sheets change weekly but the vendor listing will be complete. Payments may or may not be paid to each vendor. I need to return the value back to the total sheet
and if no payments were made I want the cell to be blank. These are 2 formula’s I have tried to use.
If there is anything you can help, I would truly appreciate it.
Thanks,
Bookmarks