+ Reply to Thread
Results 1 to 2 of 2

If index match not NA then pull result and Highlight

  1. #1
    Registered User
    Join Date
    08-30-2018
    Location
    North Bergen, NJ
    MS-Off Ver
    Office 2013
    Posts
    23

    If index match not NA then pull result and Highlight

    So essentially I'm trying to do a multiple index match. Where if it is na then index from somewhere else. The key is if it indexes from one sheet then highlight yellow, if it is from another then highlight green, and if it indexes from a 3rd then highlight blue. Is there any way in VBA coding perhaps to do this process?

    Please let me know if there is anything I may need to elaborate on.

    Initially I was trying to pull the sheet name from the result using cell("address"), but in order to do that you'd need to pull the formulatext and use indirect to convert it back into a formula. That was a whole ordeal, but I could do an Indirect(Index(Match()).

    I'm hoping that part of a formula or in a VBA code when the if function triggers to use the next index, if it could highlight it a certain color.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,743

    Re: If index match not NA then pull result and Highlight

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ 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] INDEX/MATCH more than 1 result available but only displaying the 1st result
    By MarkPr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2018, 04:48 AM
  2. [SOLVED] INDEX/MATCH generates incorrect result by referencng nearest cell if match not found
    By aglawrence in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-29-2017, 08:59 AM
  3. Replies: 4
    Last Post: 04-14-2017, 07:47 PM
  4. [SOLVED] Index/Match result should again search for zero result
    By ursanil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2014, 04:45 AM
  5. Replies: 3
    Last Post: 05-19-2014, 02:01 PM
  6. index match, ..... skip result if blank value ...... jump to next match
    By gehawk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2013, 04:42 AM
  7. Replies: 8
    Last Post: 07-09-2012, 02:38 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