Hi All,
I am trying to combine data from two spreadsheets into one. The first is a list of our payments (shows invoice number, date, amount, payable to, description etc). The second spreadsheet contains all that same information except for the description. I need a formula that will find and match the invoice number, vendor number, amount and date and will return the associated description (basically a SUMIFS formula, but resulting in text, not a sum).
Any help would be appreciated!
canadian_chickie
Bookmarks