Forum Discussion
Using Xlookup with match function to link on matching headings?
Is there a way to replicate - in Xlookup - combining the match function with a vlookup so that it returns a result based on a column heading. I'm guessing not because match uses a cell to match on a...
As variant
=XLOOKUP(
Results[@[Product Name]:[Product Name]],
Products[[Product Name]:[Product Name]],
XLOOKUP( Results[[#Headers],[Unit Price]],
Products[#Headers], Products),
"not found" )Here column names are fixed to drag entire column to the right/left and not to re-enter formula for each column.