Index Match problem

[Noz2k]

Hi, I'm relatively new to excel and have used Index Match to retrieve data from 1 table that matches a certain criteria in order to fill another table.

The problem I am having is that as the amount of data varies dependant on the location inputted by the user excel generates "N/A" for cells where there are no further values that match the criteria.

I have tried using an IFError statement to return "" instead, but because the formula has a clause in it which refers to being > than the above cell it returns the first value again after the first "" cell.

I hope this makes sense to someone, and any help would be appreciated

 

[Noz2k]

I think I need an IfError in there as well somewhere to bring back the "" originally

 

[GlennUK]

Yes, sounds good.

 

[Noz2k]

Got it working

Formula is

=IFERROR(IF($A3<>"",INDEX(Sheet2!$A$3:$A$20000,MATCH(User_Sheet!$B$1,IF((Sheet2!$A$3:$A$20000>User_Sheet!$A3)*(Sheet2!$K$3:$K$20000>=User_Sheet!$D$1)*(Sheet2!$K$3:$K$20000< User_Sheet!$E$1),Sheet2!$E$3:$E$20000),0)),""),"")

Thanks for your help