I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response.
I want to use this data to link to another sheet that I am using to track open invoices via Vlookup.
When I populate the sheet I have been inserting rows on top so the Vlookup will work
Is there another formula I can use If I update the info on the last line of data instead of the first line?
Help Article Resources
Check out the Formula Handbook template!