Sign in to submit new ideas and vote
Get Started

Better lookup formula


Implement xlookup equivalent.

Current "vlookup" sometimes requires complete sheet rearrangement to work, and can preclude a reverse lookup from working, where xlookup can lookup anything in the sheet from a key field.

Excel did this years ago and there's really no reason to ever use vlookup there on a new formula again.

4 votes

Idea Submitted · Last Updated