Today I learned

Not verified for accuracy.

It’s the internet so it must be true.

6 Likes

Even better, it was facebook.

2 Likes

Along a similar vein, Key West is closer to Havana (90 miles) than Miami (109 miles).

1 Like

ifyp

1 Like

today i saw my 1st real use of the xlookup in the wild. I don’t really actuarialize like i used to and so my data stuff is getting softer. i’d heard of it but didn’t feel like i needed it.

looks like it is versatile to use V or H and really just shrinks the commands for the index/match lookup workaround?

And the northern tip of Brazil is closer to Canada, as well as every other country in the Americas, than it is to the southern tip.

1 Like

vexillology

3 Likes

same

Yes, basically a (one dimensional) index/match.

From chatgpt

“Toi Toi Toi” is a phrase used among performers, particularly in the world of classical music and opera, to wish someone good luck. It has its roots in German-speaking cultures.

Origin and Usage:

It is thought to be a variation of the expression “toi, toi, toi,” which imitates the sound of spitting. In German folklore, spitting (or mimicking it) was believed to ward off evil spirits and bad luck.

In the performing arts, it serves as a way of wishing good fortune before a performance, akin to saying “break a leg.”

i Jewish folklore as well, i believe we had this discussion before

1 Like

Adamant is spelled just like Adam Ant, which should have been obvious, I suppose, but I thought it had an e in it.

2 Likes

Yeah, I was asking if it was appropriate to wish an opera singer “break a leg”, and it was suggested that I say “toi toi toi” instead.

1 Like

In French, that is pronounced “twa twa twa”

Boom

Well here’s where I originally asked:

1 Like

with an extra parameter if the lookup fails.

also you can string several xlookups together to lookup multiple columns:

xlookup(x,A,B, xlookup(x,C,D, xlookup(x,E,F)))

this ain’t yo daddy’s lookup

1 Like

Can you lookup to the left?

yup