+ Reply to Thread
Results 1 to 5 of 5

Using 2 separate key IDs to match a variable

  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    26

    Using 2 separate key IDs to match a variable

    Hello,

    Hope someone can help with this.

    Please see the attached sample file. What I need is to lookup the matching 2 key IDs (i.e., ISIN and Firm_Quarters) in Sheet2 and then return the variable (i.e., market cap) in Sheet1. I have done one manually highlighted in yellow. Appreciate if someone can help me with a formula that does it automatically.

    If possible, please reply to my email: mablelim@ymail.com

    Many thanks!!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Using 2 separate key IDs to match a variable

    try this
    =INDEX(Sheet2!$B$2:$AS$26,MATCH(B2,Sheet2!$A$2:$A$25,0),MATCH(Sheet1!A2,Sheet2!$B$1:$AS$1,0))
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Guru Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Using 2 separate key IDs to match a variable

    In C2

    =INDEX(Sheet2!$B$2:$AS$25,MATCH(B2,Sheet2!$A$2:$A$25,0),MATCH(A2,Sheet2!$B$1:$AS$1,0))

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Registered User
    Join Date
    10-12-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Using 2 separate key IDs to match a variable

    Many thanks Ace!!

  5. #5
    Registered User
    Join Date
    10-12-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Using 2 separate key IDs to match a variable

    Many thanks to you too, Hemesh!!!
    Last edited by mablelim; 01-06-2014 at 07:57 AM.

+ 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. [SOLVED] How to separate variable text cells
    By nztoni in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-11-2012, 10:42 AM
  2. Find Minimum Value in Variable Range (On Separate Sheet)
    By FancyCorndog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2012, 01:42 PM
  3. Multiple variable count on a separate sheet
    By Bollywood in forum Excel General
    Replies: 5
    Last Post: 07-23-2012, 01:44 PM
  4. Separate text and numbers in excel of variable length
    By anuj.lakhanpal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2008, 06:26 AM
  5. [SOLVED] Separate Variable Range of Data into Different Worksheets
    By equity7252 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2005, 02:10 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