I have a two dimensional array (maybe a table). I have a value in a column in another sheet, I need to take that value and find it in the table then read the first row value (header).
I did not declare the two dimensional array of data as table yet.
I am trying to use index match but index match does not work for two dimensional array.
Basically I have a horizontal row/header/1 dimensional array on the top [I index it] and need to find the data in the two dimensional array below it [I use match], and read the top value [where i get nothing].
Can someone help?
