Making a formula NOT array

[jpsimmon]

Hi Guys,
I have a formula that seems to be pulling the information I need well, but it functions very slow and it is an array formula. I am looking for an equivalent formula that is not array.


{=IFERROR(INDEX('2018 Import'!$H:$H,SMALL(INDEX(($A$9='2018 Import'!$A:$A)*(MATCH(ROW('2018 Import'!$A:$A), ROW('2018 Import'!$A:$A)))+($A$9<>'2018 Import'!$A:$A)*1048577,),ROWS('2018 Import'!$A$1:A6))), "-")}

Thank you

 

[Aladin Akyurek]

Try to post 10 rows from

'2018 Import'!$A:$A​

followed by 10 rows from

'2018 Import'!$H:$H​

along with the desired results.

 

[Marcelo Branco]

You can greatly improve formula performance by using defined ranges instead of entire columns.
For example,
'2018 Import'!$A$1:$A$1000
rather than
'2018 Import'!$A:$A

Adjust all the ranges for the actual or likely (in the future) size of your data.

M.