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

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

where Sheet2 is name of your Tab 2.
 
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),"")
 
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 ;-)
 
Back
Top