I have an Excel Spreadsheet with two lines.
I am trying to get the values of the top row based on a search through the values of the bottom row (Match to one value) as an array in another sheet in the same document.

I’ve already tried =INDEX(Sheet2!B$1:M$1; MATCH(B1;$B$2:$B$6;FALSE);1), however it returns a 0, most likely due to me not being used to these functions

Other sources I tried include https://www.mrexcel.com/excel-tips/excel-vlookup-index-match/ and https://support.microsoft.com/en-us/office/look-up-values-with-vlookup-index-or-match-68297403-7c3c-4150-9e3c-4d348188976b, but I’m, again, not good with them, so I turn to you, the wizards of SO.