How can I do a vlookup from a workbook with multiple sheets

[sskfare]

I have a source workbook with multiple sheets that contain gift card information which I need to bring data from into my main workbook. My main workbook contains the gift card code with redemption data. The source workbook sheets contain the gift card code with the employee who distributed the cards. How can I do a vlookup on all sheets in the source workbook at the same time and bring in the relevant data (employee name, date, client, reference code)? Let me know if examples are needed.

[PeteABC123]

This should show you how to do it.

Hope it helps.
Pete

[sskfare]

Hi Pete,

Thanks for the code - i used the array method. Would you know how to adjust the code if my destination workbook is different than the source workbook where the multi- sheets are located?

[PeteABC123]

Just change your formula to include the source workbook name in addition to the ranges and sheet names:

Please Login or Register  to view this content.

Pete