does it make sense to do a find within a find to determine some value?

i have a formula that uses index/match, but with almost 100k formulas, the calc is too long.

so basically in code, i find a value from ws1 column d (1), on ws2 column e, to get the value in column f(745).

then i use another find to find ws1 column O(331) & the found value above(745), on ws2 columns A(331) and B(745) and use some values from columns H-J to populate back on ws1.

hopefully you can see what i mean.

just not sure about the find within a find.

i have code that does it, no need to write me any code, just looking for other ideas.

--



Gary