Index Match help needed

**SKIDDERWOLF** · 05-13-2013, 06:33 AM

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.

**dilipandey** · 05-13-2013, 08:07 AM

Hi Skidderwolf,

welcome to the forum.

Try using below formula:-

Formula:

Please Login or Register  to view this content.

see attachment:-WEEK TOTAL.xlsx

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

**SKIDDERWOLF** · 05-13-2013, 08:50 AM

Thank you for your help it works perfectly.

**dilipandey** · 05-13-2013, 09:09 AM

You are welcome..

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

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

**SKIDDERWOLF** · 05-13-2013, 09:23 AM

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?

**dilipandey** · 05-13-2013, 09:26 AM

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>

**SKIDDERWOLF** · 05-13-2013, 09:34 AM

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.

**dilipandey** · 05-13-2013, 09:40 AM

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>

**SKIDDERWOLF** · 05-13-2013, 09:53 AM

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.

**dilipandey** · 05-13-2013, 10:02 AM

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>

**dilipandey** · 05-14-2013, 02:05 AM

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

Formula:

Please Login or Register  to view this content.

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

**SKIDDERWOLF** · 05-14-2013, 03:57 AM

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

Richard

**dilipandey** · 05-14-2013, 04:19 AM

No worries..

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

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

Index Match help needed

LinkBack

Thread Tools

Rate This Thread

Display

Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Re: Index Match help needed

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions