I need to search for a value in an array that has multiple rows and columns and return the value in the corresponding column/row.
In this screenshot,
Array would be the cells darkly shaded (C5:T8)
Return values in column B (B5:B8)
Search for 1 should return Course 2
Search for 2 should return Course 3