I want to use the vlookup function in two different workbooks. In sheet1 of workbook1 I have a list of all the invoices issued during the year. In workbook2 I have several sheets one for each month of the year, I use those sheets to keep track of the checking account's transactions. I want that when I enter the invoice number paid in a certain month, it automatically pastes the payment date in the workbook1 in the same invoice number.
Is this possible????
Is this possible????