Help! Formula to find a match for cell and return value of the title of that column

Well, your screenshot is unviewable - use the insert image command instead of an attachment - but the Ctrl-Shift-Enter is a three key combination similar to Ctrl-Alt-Del. After pasting the formula into the formula bar, press and hold both the Ctrl and Shift keys as you press Enter - if you do it correctly, Excel will place {} around the formula. The array entry instructs Excel to handle the interior parameters of the functions as arrays, processing them individually instead of as a group.
-
If you cannot figure out how to get it to work, attach your example workbook - there are instructions in gold at the top of the forum page/screen.