+ Reply to Thread
Results 1 to 3 of 3

Index/Match or If/isnumber/search Question

  1. #1
    Registered User
    Join Date
    03-07-2015
    Location
    New York
    MS-Off Ver
    O365
    Posts
    54

    Index/Match or If/isnumber/search Question

    I think this is an easy one I am overlooking. I thought I could use either of the formulas in the title, but no go. Open to any other ideas.

    Header Column A is the Part Number,
    Header column B is the Category Spec, (I want to keep this as a header and shift column C under it)
    Header column C is the spec criteria that I want listed under column B (B2,B3, and so on).

    What is the most efficient formula to shift column C from there to B, etc?

    Z9YHPWI.png
    Attached Images Attached Images
    Last edited by S Thibault; 02-13-2019 at 12:43 AM.

  2. #2
    Registered User
    Join Date
    03-07-2015
    Location
    New York
    MS-Off Ver
    O365
    Posts
    54

    Re: Index/Match or If/isnumber/search Question

    I can just "=" next column, but was wondering if there was a better way since there are potentially hundreds and the headers change randomly.
    Last edited by S Thibault; 02-13-2019 at 12:58 AM.

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,958

    Re: Index/Match or If/isnumber/search Question

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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] Using ISNUMBER SEARCH with INDEX MATCH
    By Emile du Toit in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-15-2020, 08:54 AM
  2. [SOLVED] Formula containing index match isnumber and search with a few Ifs thrown in, not working
    By SueBristow in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-21-2018, 05:23 AM
  3. IF ISNUMBER SEARCH AND ISERROR VLOOKUP INDEX MATCH in formula - out of my depth ;)
    By Emile du Toit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2016, 07:29 AM
  4. Index Match with nested isnumber
    By JamesArmitage in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-22-2016, 08:04 AM
  5. [SOLVED] If, ISNUMBER, SEARCH Question! Help!
    By gonoles98 in forum Excel General
    Replies: 5
    Last Post: 08-08-2014, 12:51 PM
  6. LOOKUP, MATCH, INDEX Question. (2 Search Values)
    By J00 in forum Excel General
    Replies: 1
    Last Post: 07-16-2012, 03:51 PM
  7. If(isnumber(search question
    By Wskip49 in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 02:14 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