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

#### officelife

##### New member
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
Try:

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

where Sheet2 is name of your Tab 2.

#### p45cal

##### Super Moderator
Staff member
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
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 ;-)