Hi all,

I'm looking to build a dictionary-like excel template where I can slot in new words according to categories (i.e. plant, animal, food,...etc)

I already have something build as in the attached spreadsheet below.

The problem is: I find it incredibly slow when I refresh the spreadsheet.

Therefore, my question is:

1.) Is there anyway to speed up the spreadsheet (as it takes quite a while to refresh). The main culprit , I guess, is the "=SMALL(IF(Index!$A$3:$A$8=Animal!$B$1,ROW(Index!$A$3:$A$8)),ROW(31:31))" formula. So is there any viable and better alternative?

2.) I've a "Car" category, which I would like to capture but for some reason, the spreadsheet isn't able to. Anyway to capture it?

Explanatory Note: I've a "Index" sheet as a content page for my entries. And I sort the entries according to categories in different sheets (i.e. Car, Plant, Animal and so on).

Thanks.Dictionary in Excel.xlsx