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

1. ## 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)

2. ## Re: Need help creating a formula

Hi
Also keep in mind that while pics are nice to look at, they are useless to work with. Sheets are much easier

3. ## 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

4. ## 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. ## 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.

6. ## 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

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

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