+ Reply to Thread
Results 1 to 2 of 2

Comparing 2 tabs on sheet to return a specific value in a specific cell

  1. #1
    Registered User
    Join Date
    06-05-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    1

    Comparing 2 tabs on sheet to return a specific value in a specific cell

    Sample Excel Template for formula.xlsI have 1 spreadsheet with 2 tabs.

    When the UID in tab a and tab B are the same I would like to add the value of Big commit from Tab B to Big Commit to Tab A. It's possible Tab B will have more UID numbers than tab A.

    I am having difficulty coming up with a formula.

    Sample data:

    Tab A

    UID Small Commit Small Oblig Small Exp Big Commit Big Oblig Big Exp
    123456c 10 8 8
    124567b 13 7 5
    123457d 6 5 2

    Tab B

    UID Big Commit Big Oblig BigExp
    123457d 6 2 1
    123456c 11 9 8
    124567b 10 7 5
    Last edited by Jnkemi23; 06-05-2012 at 02:09 PM. Reason: Added attachment example

  2. #2
    Forum Contributor
    Join Date
    08-14-2006
    Location
    USA
    MS-Off Ver
    2019
    Posts
    686

    Re: Comparing 2 tabs on sheet to return a specific value in a specific cell

    in Tab A E2 enter
    =INDEX('Tab B'!B:B,MATCH($A2,'Tab B'!$A:$A,0),1)

    copy over and down.

    Do you realize that sometimes the 124567b is actually 124567b-space ?
    Tab B A4 there is no space but in all other locations both Tab A & Tab B there is a trailing space

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1