Retrieving Table Header for a Value

  • 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?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!