Now the problem I have is that my source table is going to vary in size. My source table in the formula I got working below is a dynamically named range 'ImportedData'. The data in this table will always start on Row 8 but the last row of the table will vary, so the bold/red areas of the formula need to be dynamic.

Can anyone suggest how I might modify this formula to allow for the dynamic table size?

Rich (BB code):

`=IF(ROWS(B$19:B19)<=L$19,INDEX('Empower Data'!$D$8:$D$`**19**,SMALL(IF('Empower Data'!$F$8:$F$**19**=E$17,ROW('Empower Data'!$D$8:$D$**19**)-ROW('Empower Data'!$D$8)+1),ROWS(B$19:B19))),"")

Any help is appreciated.