I manage Operations at Chingu, Inc. We help bridge the knowledge you have gained via your learning activities and the experience employers seek through global remote team projects. Come join us.
Location
St. Louis
Education
Southeast Missouri State University, Webster University
Have you looked at the query function in Google Sheets? I've found it to be easier to use in many cases and more intuitive than vlookup since it brings SQL SELECT-type of functionality against spreadsheets. Note that this supports queries against other sheets, not databases (e.g. ODBC)
The one drawback I've seen is that for large spreadsheets vlookup performance seems to be much faster.
I rarely use Excel, but it may have a similar function as well.
Thanks Jim, that's a good point to bring up. There are plenty of features that (in my opinion) are underutilised. QUERY is one of them, using Gscripts is another.
As with anything in the data world it's up to the analyst which set of tools to use. There needs to be more education around the tradeoffs between them.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Thanks for a great article @helenanders26 .
Have you looked at the
query
function in Google Sheets? I've found it to be easier to use in many cases and more intuitive thanvlookup
since it brings SQL SELECT-type of functionality against spreadsheets. Note that this supports queries against other sheets, not databases (e.g. ODBC)The one drawback I've seen is that for large spreadsheets
vlookup
performance seems to be much faster.I rarely use Excel, but it may have a similar function as well.
Thanks Jim, that's a good point to bring up. There are plenty of features that (in my opinion) are underutilised. QUERY is one of them, using Gscripts is another.
As with anything in the data world it's up to the analyst which set of tools to use. There needs to be more education around the tradeoffs between them.