I have an array comprising a Header (in Row 2). The array occupies columns B to R and lets say the subsequent rows are 3 to 10.
I now wish to search the body of that table for a value (located in some other cell - call it T2) and return the value from the Header row in the column in which the value was located.
The following constraints can be assumed or must be handled:
- there will be empty cells in the table body;
- the value being searched for will be either absent or present only once.
Many thanks
Bookmarks