search of the:   for: 
code logs -> 2024 -> Sun, 04 Feb 2024< code.20240203.log - code.20240205.log >
--- Log opened Sun Feb 04 00:00:02 2024
00:01 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has quit [Connection closed]
00:03 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has joined #code
00:03 mode/#code [+qo Vornicus Vornicus] by ChanServ
01:44 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has quit [Connection closed]
03:38 Degi_ [Degi@Nightstar-s2qoo2.pool.telefonica.de] has joined #code
03:40 Degi [Degi@Nightstar-lgdv2i.pool.telefonica.de] has quit [Ping timeout: 121 seconds]
03:40 Degi_ is now known as Degi
03:50 macdjord|out is now known as macdjord
12:29 Pink [Pink@Nightstar-ti9g6v.sub-75-222-108.myvzw.com] has joined #code
14:58 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has joined #code
14:58 mode/#code [+qo Vornicus Vornicus] by ChanServ
15:26 ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [The TLS connection was non-properly terminated.]
15:26 ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code
15:27 mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ
16:09 ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [The TLS connection was non-properly terminated.]
16:10 ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code
16:10 mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ
16:31
< abudhabi>
It never fails to impress me just how unintuitive vlookup() is.
16:31
< abudhabi>
It works, but I need a manual every time. :V
16:31
<@celticminstrel>
Good thing there's an inline manual…?
16:32
< abudhabi>
Kind of.
16:32
<@celticminstrel>
(At least in Excel and Numbers. I don't remember if Google Sheets or LibreOffice have that.)
16:32
< abudhabi>
You glance at the parameters, and that intuition steers you wrong.
16:33
< abudhabi>
vlookup(value, range, column). value is just what it says on the tin. Range is just what it says on the tin.
16:33
< abudhabi>
Column is a column NUMBER.
17:06
<~Vornicus>
xlookup supremacy
18:05
<@celticminstrel>
Also, isn't the column number relative to the range, not the sheet? I'm sure that has confused someone.
18:09
< abudhabi>
Yes.
18:50 Vornicus [Vorn@Nightstar-ivektl.res.spectrum.com] has quit [Connection closed]
20:25
<&Reiver>
And it's 1-indexed!
20:25
<&Reiver>
For bonus points.
20:44
<@celticminstrel>
That's probably more intuitive tho.
20:45
<@celticminstrel>
Well, for anyone who isn't a programmer.
21:09
<&ToxicFrog>
That was the rationale for making lists in Lua 1-indexed as well, with mixed success.
21:26
<@celticminstrel>
I don't think Lua was the first to do that tho…
23:30
<&McMartin>
BASIC encouraged pretending it was true, even though it wasn't
23:30
<&McMartin>
Pascal strings are 255 bytes max, and byte 0 is the length, so they're also "1-indexed in practice"
--- Log closed Mon Feb 05 00:00:03 2024
code logs -> 2024 -> Sun, 04 Feb 2024< code.20240203.log - code.20240205.log >
 search of the:   for: 

[ Latest log file ]