Reduce Multiple use of Array

[Maulikbagadiya1988]

Hi All,

I am using the following formulla in excel atleast 2000 times. Becuse it is having array function the file is getting heavy. Can someone suggest me alternate formula please.

{=IFERROR(INDEX($U$6:$U$10000,SMALL(IF(ISNUMBER(MATCH($T$6:$T$10000,$AY6,0)),MATCH(ROW($T$6:$T$10000),ROW($T$6:$T$10000)),""),AZ$5)),"")}

[#2]

Hi

Alternatives:

- Filter

- Advanced Filter

- Pivot table

- Power Query