News for hackers. Stuff that matters.
Re:XLOOKUP for Excel by ttul on Saturday August 31, 2019 @10:46AM (#20846572)
Anyone here on the GSuite team who can get this into Sheets stat?
Re:XLOOKUP for Excel by medmunds on Saturday August 31, 2019 @12:00PM (#20847079)
If you're using Google Sheets, the QUERY function [1] can do all kinds of lookups. For complex logic, I find its SQLish syntax a lot more readable than mixtures of VLOOKUP and IF and other functions (but that might just be me). So, um, anyone here on the Office team who can get QUERY into Excel?

[1]: https://support.google.com/docs/answer/3093343?hl=en

Re:XLOOKUP for Excel by nefitty on Saturday August 31, 2019 @11:27PM (#20850331)
My office is split between Excel and Sheets users. I was once trying to mash-up my Sheets knowledge with an Excel colleague. I told him it might be easier to accomplish his task with Sheets because query() uses a SQL-like syntax. I told him Excel doesn't have that. He responded, "lmao you can do that with vb". I looked up instructions on how to that and realized he had no idea what he was missing.
Re:XLOOKUP for Excel by coagmano on Monday September 02, 2019 @03:36AM (#20857392)
Anything that requires VB is not friendly. Of course there's a sheets equivalent using javascript, which you can say the same thing about
Re:XLOOKUP for Excel by fomopop on Saturday August 31, 2019 @11:11AM (#20846716)
Not identical, but this fuzzy match is a life changer.

https://gsuite.google.com/marketplace/app/flookup/5938060149...

Re:XLOOKUP for Excel by rayshan on Saturday August 31, 2019 @12:43PM (#20847365)
+1 works well but long calculate times