officelife
New member
- Joined
- Mar 20, 2014
- Messages
- 5
- Reaction score
- 0
- Points
- 0
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!!
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!!