Hi

I have data being written into a worksheet by a macro, most recent at the bottom. I've noticed that when I add this function =LOOKUP(2,1/(A$2:A$22=G2),B$2:B$22) into my reporting worksheet to retrieve the most recent entry it hits performance massively (I'm using VLOOKUP elsewhere; there's just one instance where I need the search bottom-up). The overall workbook is <100KB, yet when I add this formula I immediately get the dreaded 'calculating processors' when I run the macro.

Does anyone have a good alternative that's more efficient?