Hi,

Is it possible to write a lookup function that searches a two-dimension array (rows and columns), and returns the header value for the column that the lookup was found in?
Everything I've found online references a situation where you want to return from a vertical array, but in my case, the return would be a value in a horizontal array (header row).
See attached for sample file.
Thank you

ExcelForum - xtinct2 - 2023.06.15.xlsx