[nhinck2]

It depends on the join you want to do but it is definitely possible to do joins as formulas in excel.

[klysm]

Yes that’s true but you have to jump through a lot of hoops. I want to be able to write like a sql style join on tables with named columns