> 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 in

> 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.