upgrade vlookup() (and hlookup()) so that you can provide the column header text instead of column number. i.e. database search - dget()
Excel has the DGET() function that allows a database search. You give the name of the column it should find the match in, and the name of the column where the value should be returned to. If vlookup can be upgraded to be similar, then it will be much more powerful:
newVlookup(value, data range, match column, return column, match type)
newVlookup(Sheet1!A1,Sheet2!A:E,"Order Number", "Order Description", false)
(Sigh... ) 15 years ago it used to do precisely this...
And with implicit intersection you could use those labels ("Use column headers as labels") like so:
to get (in this example) sales for the East region in 1998 without building Named Ranges.
Now, with the new array formulas (spill formulas), they tout the idea that implicit intersection is completely going away too.
You eveil people! Just use Tables, period! Get with it! Seems to be their thinking...