+ Reply to Thread
Results 1 to 2 of 2

Combine Two Index Match into One

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Combine Two Index Match into One

    Hi,

    I want to join the below two index matches with ":" between the two and "/" in the end.

    How to do this please

    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2013
    Posts
    350

    Re: Combine Two Index Match into One

    Sorry got it

    =INDEX(Ticker!D:D,MATCH(B7,Ticker!B:B,0))&"."&INDEX(Ticker!C:C,MATCH(B7,Ticker!B:B,0))&"/"

+ 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. How to combine v lookup with index match
    By akshay6s in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-15-2022, 04:59 AM
  2. Combine index match and IF
    By apple99 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-01-2021, 03:51 AM
  3. [SOLVED] how to combine index, match and IF
    By seraphin in forum Excel General
    Replies: 2
    Last Post: 04-14-2020, 05:03 PM
  4. [SOLVED] Combine If with Index Match
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2019, 12:54 PM
  5. Combine SUM, INDEX and MATCH
    By abrj in forum Excel General
    Replies: 7
    Last Post: 12-14-2018, 02:56 PM
  6. [SOLVED] Combine MATCH and INDEX
    By SubwAy in forum Excel General
    Replies: 13
    Last Post: 05-31-2012, 11:53 AM
  7. How to combine the INDEX and MATCH functions?
    By Anna A in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2010, 03:47 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