Slow index/small/row array

I am trying to select companies from list of 7000 companies by two criteria.
1. 7000 companies with corresponding values
2. Based on that values (I have a combo box) companies are selected from that list of 7000
3. Using combination of index/small/row functions, that selection is sorted in another column to ignore blank cells
4. Whole process is repeated one more time using second criteria.

If someone could check uploaded workbook for another method for index/small/row array to speed up the whole process.
I know it's not that slow right now, but with fetching web data and with other calculations that comes after that process
opening time is pretty slow.

LIST_SPEED TEST.xlsm

Hi Jovica,

I noticed few things:-

1) This may be for a reason but I feel un-necessary duplication of data on tabs.
2) Try using Index - Match instead of Vlookup

Regards,
DILIPandey

<click on below 'star' if this helps>

okay.. that's great.

Also consider my first point as well .. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

You seem to be trying this the hard way! ...

See if this workbook helps, it seems to be a tad faster.

Select from the drop-downs in Sheet1!B1:B3

I might have read some of your intentions wrongly, but it should be easy enough to make any changes you need.