hi

new to this forum and new to advanced Excel/formulas, so would appreciate any expert advice.

Ive got 2 workbook tabs. I need the value of Tab2,ColumnI to populate Tab1,ColumnU, but only if the values in ColumnA of both tabs are matching. (There is only one column in common between the 2 tabs, Column A in both tabs).

Is there a formula to enable this?

many thanks!!