Re:Ask HN: Programs that saved you 100 hours? (2022 edition)
by liotier on Tuesday December 20, 2022 @03:50PM
(#34072342)
> The ability create a relational database in Excel with vlookups and hlookups,
Do yourself a favour and ditch vlookup and hlookup in favour of the recently introduced xlookup, which even obsoletes index/match !
I try to keep my exploratory joins out of Excel, but I admit that I often don't resist the immediacy of Excel's poor man's joins located right where I need them.
Do yourself a favour and ditch vlookup and hlookup in favour of the recently introduced xlookup, which even obsoletes index/match !
I try to keep my exploratory joins out of Excel, but I admit that I often don't resist the immediacy of Excel's poor man's joins located right where I need them.