IFERROR Function based on multiple criteria

Hi there - I've got a workbook that's collecting data from one sheet and creating a list based on two sets of criteria in another. I am using the following formula which is working fine but I need to add an additional test to this formula along the lines of 'Table 1'!$A$9:$A:1509="Leeds"

=IFERROR(INDEX('Table 1'!$G$9:$G$1509,SMALL(IF('Table 1'!$B$9:$B$1509="Awarded",ROW($G$9:$G$1509)-ROW($G$9)+1),ROWS($G$9:$G9))),"")

Currently it's populating everything under "Awarded" so I need to insert a second condition so that anything that is not listed against "Leeds" is not included as I will be creating further tables for other locations elsewhere in the workbook.

Note - I am using ctrl+shift+enter to close this. Like I said, all working fine so far just unable to add second test.

I can't upload unfortunately as work with sensitive data - sorry, I know that's not very helpful.

Hi & welcome to the board.
How about
=IFERROR(INDEX('Table 1'!$G$9:$G$1509,aggregate(15,6,(row('Table 1'!$G$9:$G$1509)-row('Table 1'!$G$9)+1)/(('Table 1'!$B$9:$B$1509="Awarded")&( 'Table 1'!$A$9:$A:1509="Leeds" ),rows($G$9:$G9)))

This is a normal formula, no need for CSE

Hi there - thanks for responding! Unfortunately it's returning an error... I added a $ to the last row part of the Leeds condition in case it was that but it's still not working. May I ask what the 15,6 after aggregate is for? I'm a novice when it comes to this so like to keep notes on all the help I get in case it comes in handy for other bits of work...

Hi Glenn - thanks for assisting. It's still returning an error - not sure if this helps but the error box is as follows:

AGGREGATE(function_num,options, array ,[k]
AGGREGATE(function_num,options,array, ref1

Didn't do a very good job with that
with all corrections, it should be
=IFERROR(INDEX('Table 1'!$G$9:$G$1509,aggregate(15,6,(row('Table 1'!$G$9:$G$1509)-row('Table 1'!$G$9)+1)/(('Table 1'!$B$9:$B$1509="Awarded")*('Table 1'!$A$9:$A$1509="Leeds")),rows($G$9:$G9)))

The 15 signifies SMALL and the 6 instructs it to ignore errors.

Next time I'd better do it in Xl, rather than free typing on the board.

=IFERROR(INDEX('Table 1'!$G$9:$G$1509,AGGREGATE(15,6,(ROW('Table 1'!$G$9:$G$1509)-ROW('Table 1'!$G$9)+1)/(('Table 1'!$B$9:$B$1509="Awarded")*('Table 1'!$A$9:$A$1509="Leeds")),ROWS($G$9:$G9))),"")

Thanks to you both - the formula is fixed and now working so all sorted. Much appreciated! Have a lovely evening

You're welcome & thanks for the feedback