+ Reply to Thread
Results 1 to 3 of 3

How to multiply matching 2 cells with 2 different cells of 2 different table

  1. #1
    Registered User
    Join Date
    08-21-2015
    Location
    Dhaka
    MS-Off Ver
    2010
    Posts
    2

    How to multiply matching 2 cells with 2 different cells of 2 different table

    excell help.PNG

    Hello,

    Can anyone pls help me to get the result in Cell K15 (of attached excel chart) as below:

    K15= ( J15* a value( either "C5" if E15 & F15 matches with table B1: C8 or " F5" if E15 & F15 matches with table E1:F8)

    I have attached the dummy table here. I hope i am able to make clear what i actually want.

    If further info needed pls let me know.

    Advance Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: How to multiply matching 2 cells with 2 different cells of 2 different table

    Are you sure the figures you have in K13 to K18 are the figures you want? They seem all to be multiples of the number in column J with either C8 or F8. For example, K15 is 84, which is 2 * 42 (J15 * C8). I would have expected it to be 28, being 2 * 14 (J15 * C5).
    If your figures are correct, then put this in K13 and drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    To get the figures I'd expect, put this in K13 and drag down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope that helps.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: How to multiply matching 2 cells with 2 different cells of 2 different table

    Thanks for the rep and feedback by PM.

    For anyone else who looks at this thread, the "–" at the end of the formulae just put a hyphen in the cell if the number in column E doesn't match either of C1 or F1. I should really have put something like "no match" instead, to be clear.

+ 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: 7
    Last Post: 07-19-2015, 07:34 PM
  2. Matching two cells of data to info from a pivot table
    By culpepper in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2014, 12:13 PM
  3. [SOLVED] Matching combination of two cells with a table and return value
    By coconutxyz in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2014, 10:09 AM
  4. [SOLVED] Search for matching cells in table
    By neek13 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-22-2014, 05:23 PM
  5. Help matching cells and then looking at other column based on those matching cells
    By Ppessina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2013, 02:37 PM
  6. VBA Multiply Cells in one Range by Cells in Another
    By mkeys4 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2013, 09:26 AM
  7. Multiply two cells based on information in two other cells
    By stanster in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2012, 10:04 AM

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