Results 1 to 10 of 10

Index Match / Vlookup / Other formula needed

Threaded View

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    Doncaster
    MS-Off Ver
    Excel 2003
    Posts
    5

    Index Match / Vlookup / Other formula needed

    Hello all

    I have been trawling this forum and google to try and get an answer to my problem but so far had little luck for the way I would ideally like it to work.

    Untitled-2.jpg

    Above is the spreadsheet I am trying to sort, I would like the desired results to show as per J3:J10. The result depends on the yellow box (J1) to correspond to row 2 and also only display the colors in column B if there is a "O" in the column that matches J1.

    I also don't want any empty cells when colors aren't available.

    This might be something very simple but i'm not sure of the terminology to find the right answer.

    Thank you in advance for taking the time to look.
    Attached Files Attached Files
    Last edited by rustywrightone; 08-18-2017 at 09:50 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. IF INDEX MATCH formula help needed
    By keith_parks in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2017, 04:33 AM
  2. Multi Tier - Match & Vlookup or INDEX or INDIRECT function help needed
    By yogananda.muthaiah in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2016, 12:32 AM
  3. [SOLVED] Vlookup or Index Match Formula Needed
    By artiststevens in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2015, 01:09 AM
  4. Replies: 2
    Last Post: 09-27-2014, 04:34 PM
  5. Index match formula help needed
    By mrteater in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2014, 09:41 AM
  6. [SOLVED] INDEX & MATCH formula help needed please
    By Twaddy006 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2014, 12:30 PM
  7. [SOLVED] Index, Match, Vlookup, Hlookup help needed
    By Gemma_10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-20-2013, 01:05 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