new to formulas so this should be an easy one for you experts!

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!!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Try:

=INDEX('Sheet2'!I:I,MATCH(A2,'Sheet2'!A:A,0))

where Sheet2 is name of your Tab 2.
 

p45cal

Super Moderator
Staff member
Joined
Dec 16, 2012
Messages
2,200
Reaction score
16
Points
38
Excel Version(s)
365
If the the values in column A are in the same rows then in U2 of Sheet1:
=IF(A2=Sheet2!A2,Sheet2!I2,"")
If they are not inthe sam order, in U2 of sheet1:
=VLOOKUP(A2,Sheet2!$A$1:$I$7,9,FALSE)
whicH if you're using Excel 2007 upwards you can tidy errors with:
=IFERROR(VLOOKUP(A2,Sheet2!$A$1:$I$7,9,FALSE),"")
 

officelife

New member
Joined
Mar 20, 2014
Messages
5
Reaction score
0
Points
0
If the the values in column A are in the same rows then in U2 of Sheet1:
=IF(A2=Sheet2!A2,Sheet2!I2,"")
If they are not inthe sam order, in U2 of sheet1:
=VLOOKUP(A2,Sheet2!$A$1:$I$7,9,FALSE)
whicH if you're using Excel 2007 upwards you can tidy errors with:
=IFERROR(VLOOKUP(A2,Sheet2!$A$1:$I$7,9,FALSE),"")


the very last one worked for me :) thanks a million! i

am sure you havent seen the last of me here ;-)
 
Top