Multiple dropdowns to filter excel sheet

[bohon79]

Good afternoon,

Hopefully someone can help out as i am stuck. have a sheet with data that i would like to filter data out as i use multiple drop downs.

i have all the dropdowns setup with the formula's setup in the cells i need. the issue i run in to is i can only filter one thing and not multiple. below is the formula the filer:

=IFERROR(INDEX($A$2:$R$500,$U2, COLUMNS($AK$2:AK2)),"")

U2 is the first column used to filter. i also have X2, AA2, AD2, and AG2

any help would be greatly appreciated.

 

[bohon79]

i have uploaded a screen shot. hopefully you can see.

 

[bohon79]

hello,

i was able to figure it out using indexmatch. but try to do it with multiple drop downs to narrow the search. below is the indexmatch i am using.

INDEX(working!A2:A267,MATCH($C$3,working!$F$2:$F$267,0))

erick