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...
Not exactly what you asked, but the formula in C4
=XLOOKUP(Results[@[Product ID]:[Product ID]],Products[[Product ID]:[Product ID]],INDEX(Products,0,XMATCH(Results[[#Headers],[Product Name]],Products[#Headers])),"not found")
can be filled to the next columns.