Forum Discussion
Combining VLookup, max and other formulas to find customer's most recent visit - guidance?
Hello! Looking for some help with a formula - attaching an example spreadsheet with some simple data. My data are in two tabs - it needs to stay that way. On the second tab, I would like a formula th...
I've heard rumors of VLOOKUP being obsolete! I think it's fine to use when you don't want to split the table array. Though in most cases XLOOKUP is a better option.
Here's what a VLOOKUP solution looks like for this one:
=LET(sorted, SORT('Raw Visit Data'!B3:D17, 3, -1), VLOOKUP(B3:B6, sorted, 2, 0))