How do I return Last Match with VLOOKUP

Brandon Tong

Hello,

My VLOOKUP function is always returning the first match other than the last match.

The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match.

I'm open to other solutions that use other functions.

Thanks.

David Joyeuse

Hi @Brandon Tong

I'd suggest use using some MAX/COLLECT formula instead of VLOOKUP in your case.

Hope it helped!