Results 1 to 4 of 4

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try:

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

    where Sheet2 is name of your Tab 2.


  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,356
    Articles
    0
    Excel Version
    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),"")

  4. #4
    Quote Originally Posted by p45cal View Post
    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
  •