Question Locked

how can I join 2 excel worksheets

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have 2 worksheets which are downloaded daily, a PO file and an AP file, each sheet has approximately 20 columns, 2 of which are common to both sheets. I'd like to join both sets of information.

2 replies

by oldbaritone

then use the LOOKUP() function and you can match data from the common columns between the sheets

This discussion is closed to new replies.