Limit DropDown List Results Based on Other Data

Hi Everyone,

I've tried to do this myself but have not had any luck or have not found the answer online. In the attached sheet, you'll see that I am trying to create a drop down list of locations. Once a location is selected, it will generate another list "Size of Presses" which will only show sizes of presses which have prices from the Machine Rates Worksheet.

I cannot use macros for this as others will be working with it and macros can be complicated for other people...

Any help will be much appreciated!

-MK

Hope this works..........


regards

NeedForExcel
Re: Limit DropDown List Results Based on Other Data

Here!

In I2

=IFERROR(INDEX($A$3:$A$62,SMALL(IF(INDEX($B$3:$E$62,0,MATCH($H$2,$B$2:$E$2,0))>0,ROW($A$3:$A$62)-ROW($A$3)+1,""),ROWS($I$2:I2))),"")

J2

=IFERROR(INDEX($B$3:$E$62,SMALL(IF(INDEX($B$3:$E$62,0,MATCH($H$2,$B$2:$E$2,0))>0,ROW($A$3:$A$62)-ROW($A$3)+1,""),ROWS($I$2:J2)),MATCH($H$2,$B$2:$E$2,0)),"")

Drag Down! See the file attached..

Whenever I copy the J2 or even click on it, the answers disappear. I've been trying to replicate your formula for the I2 and J2 but cannot seem to make it work. What may I be doing wrong?