Merging multiple documents into one, but need some type of vlookup functionality for final

Question

So I've been scouring the boards trying to find the one solution that works for me...I know I'm close...

I've used joins and unions and just can't seem to get it right. I am merging two documents with a 'Patron Code' and a 'Customer Name' tied together in two seperate columns. Once I have those two columns apended to each other, I need to look against a third document and if a patron code from the previous merged document IS there, I want that to come out on the report with ALL the data that is on the third document. Any suggestion would be helpful

fmvizcaino · Accepted Answer

Hi @dberroth ,

If I understood your problem right, you can solve it by adding a join tool after your union tool using the patron code as a key field. Would that work for you? If not, please share a bit more detail about your problem, please.

Best,

Fernando Vizcaino