How to Copy and Paste Information if Contents of Another Cell Match

Hi all,

I have the attached workbook with two sheets (contents of cells have been removed/changed for privacy reasons). I would like it so that if a "Firm" number anywhere in Column A on both sheets match, to copy the details from the respective row on the Emails sheet, in columns Q, R, S, and T, and put it into the row containing the same "Firm" number, into columns O, P, Q, and R, on the Levy worksheet.

For example, John Smiths details from the Emails worksheet should automatically end up in O4:R4 in the Levy worksheet.

Thanks
Glenn

Try in O2 and copy across and down:

Formula:

Please Login or Register  to view this content.

Good luck!

That worked perfectly! TYVM

You’re welcome. Glad to help.
Thank you for the feedback and for the reputation added.
Have a blessed day.