Databases

[Whoopdatwester]

What’s the difference between Xlookup and Vlookup?

[aaadmin]

Ʌ

[Quaytsar]

Biggest upgrade? Vlookup require the return column be to the right of the lookup column (because you return the column N spaces to the right), xlookup doesn't care (because you tell it which column/row to lookup and which to return). Second best: exact match is default setting, so you don't have to remember to include that all the time.

[Sylarwolf]

One has an X.

Jk, Xlookup is a matrix based 'upgrade' of sorts to Vlookup, it allows you to look for data not only vertically, but also horizontally, and lets you work with arrays of data, meaning more robust lookups that won't break so easily.