+ Reply to Thread
Results 1 to 3 of 3

Index Formula Problems

  1. 07-02-2022, 08:32 PM #1
    jjward101
    Guest

    Index Formula Problems

    Hi.

    I have a large list of technical data sheet names, with the links to their location on the wen in the next column. I carefully watched a youtube video, and was able to get what i am trying to do to work 80%.

    What Am I Trying To DO?!?!

    I have a dropdown box that lists the category for each type of product. When a category is chosen, the names of the data sheets populate below, and the associated link to the data sheet in the next cell, kind of in a filtered list type of way.

    What is not working?

    I have been able to successfully populate the column with the product names, but when i carry the formula to the column that should contain the link, all I see are '0's. I am not sure why.


    I have attached the workbook. If anyone could point out the error I am making that is stopping this from working I would be super thankful.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-02-2022, 10:41 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: Index Formula Problems

    Get rid of those merged cells on tab: DATA. Then on SEARCH,
    C13:
    Please Login or Register  to view this content.
    Last edited by protonLeah; 07-02-2022 at 11:18 PM. Reason: added error check
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 07-02-2022, 11:48 PM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Index Formula Problems

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Problems with dataset (Index-formula)
    By Proalv in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-21-2021, 03:53 AM
  2. [SOLVED] Problems with Index Match formula
    By erasmusthesis in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-02-2019, 05:37 AM
  3. Formula problems - IF, IFERROR and INDEX functions
    By Felics99 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2017, 11:16 AM
  4. Problems with Index / Match Formula
    By TMC2016 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-18-2016, 05:04 PM
  5. [SOLVED] Problems with Index and Match formula
    By aglopez08 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2013, 03:33 PM
  6. Lookup using INDEX and MATCH, having problems with formula
    By rfcapinto in forum Excel General
    Replies: 2
    Last Post: 10-03-2011, 01:29 PM
  7. [SOLVED] Problems with INDEX formula
    By bc in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-28-2006, 06:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1