+ Reply to Thread
Results 1 to 6 of 6

Formula That Links Cells In Tables Together With Cells Not In The Table And Give The Sum

  1. #1
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    83

    Formula That Links Cells In Tables Together With Cells Not In The Table And Give The Sum

    Hi Guys and Girls. I'm very new to Excel Forum. I'm in need of help creating the right formula for a Worksheet I'm currently on.
    What I'm trying to do is link a cell to give me the sum of 2 different cells located in 2 different tables I created.

    So I want to have Cell B5 look for the number in cell B3 in the Table that starts in column Q1 and give me the corresponding number in the same row in the column R1

    then lookup the number in cell B1 in the Table that starts in column T1 and match it with the number in Column U1 that corresponds to it in the same row

    and Finally give me the sum of both corresponding numbers.

    IE.. the number in B3 is found in Q13 which uses the number it corresponds to in R13. The takes B1 finds it in T16 and uses the number it corresponds to in U16.
    Then returns the sum of R13 and X16 into B5. (B5 should show 176)
    Attached Images Attached Images
    Last edited by TwistedFaith; 04-29-2014 at 07:52 PM. Reason: I Moved The Table Around

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,431

    Re: Need help creating a formula

    Hi
    perhaps first have a look at forum rules about thread titles.
    Also keep in mind that while pics are nice to look at, they are useless to work with. Sheets are much easier
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

  3. #3
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    83

    Re: Formula That Links Cells In Tables Together With Cells Not In The Table And Give The S

    Ok Here Is My Attached Page That I need Help With
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    83

    Re: Formula That Links Cells In Tables Together With Cells Not In The Table And Give The S

    Well I Guess No1 is going to help me figure this out. Otherwise I hope some1 will say that they are working on it.

  5. #5
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: Formula That Links Cells In Tables Together With Cells Not In The Table And Give The S

    formula in B5:

    Please Login or Register  to view this content.
    this will be fast, but will work only if columns Q and T are sorted ascending.

    else, use this, if any value in Q and T appears only once:

    Please Login or Register  to view this content.
    or, there is also:

    Please Login or Register  to view this content.
    or,

    Please Login or Register  to view this content.
    this will only look in the left-most column for index values.
    Last edited by icestationzbra; 04-30-2014 at 12:20 AM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  6. #6
    Registered User
    Join Date
    04-18-2014
    Location
    USA
    MS-Off Ver
    MS Office 2010
    Posts
    83

    Re: Formula That Links Cells In Tables Together With Cells Not In The Table And Give The S

    Thanks icestationzbra You really helped me alot. I'm very Noob when it comes to formulas in excel. I do now how to use some of them but still learning

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-21-2012, 02:03 AM
  2. creating an IF formula
    By excelmaster5000 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2008, 02:25 AM
  3. Creating a formula
    By khalid79m in forum Excel General
    Replies: 4
    Last Post: 10-02-2007, 10:49 AM
  4. Help with creating a formula
    By Peter Barker in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2006, 02:05 PM
  5. need help creating a formula
    By Matt in forum Excel General
    Replies: 1
    Last Post: 10-12-2005, 01:05 PM

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