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.
[ Parent
| on HN ]