AFAIK, Excel has no function allowing simultaneous search for 1 value
along leftmost column of a table range and then also search
horizontally across table top row.

1 way to do this is to embed a LOOKUP to figure out how many columns or
rows to index over (in case of VLOOKUP/HLOOKUP respectively).

Anything else?