+ Reply to Thread
Results 1 to 13 of 13

Index Match help needed

  1. #1
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Index Match help needed

    WEEK TOTAL.xlsx

    Sheet 3 is an overview sheet from the packroom sheet which I want to be able to select a production cell and see its output. I have the sheet working but when selecting a cell I will get other cell data imported too. How do I stop this happening.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    Hi Skidderwolf,

    welcome to the forum.

    Try using below formula:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    see attachment:-WEEK TOTAL.xlsx

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Index Match help needed

    Thank you for your help it works perfectly.

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    You are welcome..

    Please mark this thread as [SOLVED]... thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Index Match help needed

    I have tried using the same formula to extract data from the laser and final visual sheets but cannot get it to work, Surely this is just a case of copy and paste and then change the cell ranges?

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    Yes.. you can check the ranges in the sheet where formula is working and then understand the data flow and do changes in the formula accordingly.
    e.g., see the starting row of data, end row, freezing ($) etc.


    Regards,
    DILIPandey
    <click on below * if this helps>

  7. #7
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Index Match help needed

    Cannot seem to get it working I have this

    =IFERROR(INDEX('Laser Product'!$B$4:$U$68,SMALL(IF('Laser Product'!$H$4:$H$68=$C$1,ROW('Laser Product'!$H$4:$H$68)-3,""),ROW(A1))),"")

    to extract data from the laser product sheet but It does not seem to work.

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    and where you are applying this formula .. i.e., in which sheet ?
    Can you upload a sample workbook ? thanks


    Regards,
    DILIPandey
    <click on below * if this helps>

  9. #9
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Index Match help needed

    WEEK TOTAL.xlsx

    Attached. The tabs in blue work good, the tabs in green cell 2 needs to pull data from laser product. I have used the same formula but changed where it looks but it does not work. I have doubled checked this but no luck.

  10. #10
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    Okay.. I am rushing .. will look into it later - may be after 2-3 hrs.. stay tuned


    Regards,
    DILIPandey
    <click on below * if this helps>

  11. #11
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    I simply copied the working formula and changed the sheet name in that

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards,
    DILIPandey
    <click on below * if this helps>

  12. #12
    Registered User
    Join Date
    02-14-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Index Match help needed

    Thankyou, I don't know what I was doing wrong but I have it all working now

    Richard

  13. #13
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Index Match help needed

    No worries..

    Please mark this thread as [SOLVED].. thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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