Hello,

I'm doing a match index for about 200+ different values.
My formula looks like this:
=INDEX('Part Info'!E:E,MATCH(1,('Part Info'!A:A=A1)*('Part Info'!B:B=B1),0))

It takes a really long time to calculate all 200+ values.
Is there anyway to speed this up?

Please let me know!

Thanks in advanced