+ Reply to Thread
Results 1 to 5 of 5

Possibly a complicated index match?

  1. #1
    Registered User
    Join Date
    03-08-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    33

    Question Possibly a complicated index match?

    Got a tricky one here. Is it possible to draw through the % number in column D on sheet 1 with the corresponding code (C1) that comes with choosing a name from the list in B1 in conjunction with the risk and objective in column C.

    So for example if you select Alibaba in B1 then the first 2 accounts should read 1.89 and 1.75 respectively, the data being matched to the SEDOL code by the column headers on sheet 2. As another example if you chose Amazon.com then the first two accounts should read 1.61 and 1.49 respectively etc etc.

    Many thanks in advance
    Attached Files Attached Files
    Last edited by jcswaby; 04-19-2020 at 03:08 AM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Possibly a complicated index match?

    Hi jscwaby,
    This formula should do ya.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See it in the attached: Offset Match Row Match Col.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Possibly a complicated index match?

    Another option
    =INDEX(Sheet2!$D$2:$L$65,MATCH($C$1,Sheet2!$C$2:$C$65,0),MATCH(C3,Sheet2!$D$1:$L$1,0))

  4. #4
    Registered User
    Join Date
    03-08-2015
    Location
    UK
    MS-Off Ver
    2013
    Posts
    33

    Re: Possibly a complicated index match?

    Both of those work beautifully, thanks guys.

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Possibly a complicated index match?

    You're welcome & thanks for the feedback

+ 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. Index/Match possibly? Match data from one sheet to another
    By kg0332 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2018, 05:29 PM
  2. [SOLVED] Vlookup or index match possibly needed
    By Noah101 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2017, 02:48 AM
  3. [SOLVED] Need help with Index Match or possibly array type of match
    By chadboehne in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2017, 01:16 PM
  4. Vlookup with index/match possibly.
    By Kramxel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-05-2015, 06:06 AM
  5. INDEX/MATCH with multiple arrays. Possibly need IF Function as well?
    By guy lafleur in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2015, 03:13 PM
  6. [SOLVED] Advanced Match Help (possibly Index Match)
    By dfxryanjr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-08-2013, 09:13 AM
  7. Replies: 6
    Last Post: 01-03-2012, 07:36 PM

Tags for this Thread

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