Find match for nth value with multiple criteria

[Godwin117]

I have this formula, I feel I am making a very small mistake, but I keep receiving the #N/A error. I've been working on trying to find a fix to it for about 2 days now, any help would be greatly appreciated.
1 2 3 4 5 2 2 6
=INDEX('1 SUS BDE'!C6:C3500,SMALL(IF('1 SUS BDE'!B6:B3500=UICs,IF('1 SUS BDE'!J6:J3500=D5, ROW('1 SUS BDE'!B6:B3500)-ROW(INDEX('1 SUS BDE'!B6:B3500,1,1))+1)),1))

The numbers above the formula help with what I'm referring to.

1. Is the data that I am trying to match to print in the current cell
2. Is where the first range is located
3. Is where the first criteria is located
4. Is where the second range is located
5. Is where the second criteria is located
6. Is what nth number I'd like to reference

 

[Peter_SSs]

Try putting quote marks around "UICs" if that is text that you are trying to match in column B

 

[Godwin117]

Try putting quote marks around "UICs"

The UICs is a list, I don't think I mentioned that in my original post.

 

[Peter_SSs]

I don't think I mentioned that in my original post

No, you didn't.

In that case try
=INDEX('1 SUS BDE'!C6:C3500,SMALL(IF(ISNUMBER(MATCH('1 SUS BDE'!B6:B3500,UICs,0)),IF('1 SUS BDE'!J6:J3500=D5,ROW('1 SUS BDE'!B6:B3500)-ROW(INDEX('1 SUS BDE'!B6:B3500,1,1))+1)),1))

 

[Godwin117]

No, you didn't.

In that case try
=INDEX('1 SUS BDE'!C6:C3500,SMALL(IF(ISNUMBER(MATCH('1 SUS BDE'!B6:B3500,UICs,0)),IF('1 SUS BDE'!J6:J3500=D5,ROW('1 SUS BDE'!B6:B3500)-ROW(INDEX('1 SUS BDE'!B6:B3500,1,1))+1)),1))

Thank you, that worked perfectly.

 

[Peter_SSs]

Thank you, that worked perfectly.

You're welcome. Thanks for the confirmation.