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

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

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

2. Try:

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

where Sheet2 is name of your Tab 2.

3. 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),"")

4. Originally Posted by p45cal
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 ;-)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•