Hi,
In a table of data, I'm using INDEX-MATCH to return a value from the Header_Row, based on the column of a Target_Value. With a fixed Search_Row, the formula is:
=INDEX(Header_Row,1,MATCH(Target_Value,Search_Row,-1)+1) This works perfectly.
But, the table has 10 rows, with Names in column A7 to A17 and numbers in the range C7 to AB17.
How can I make the reference Search_Row dynamic, determined by the chosen Name?
Chris
Someday I'll know what I'm donig...damn!
In a table of data, I'm using INDEX-MATCH to return a value from the Header_Row, based on the column of a Target_Value. With a fixed Search_Row, the formula is:
=INDEX(Header_Row,1,MATCH(Target_Value,Search_Row,-1)+1) This works perfectly.
But, the table has 10 rows, with Names in column A7 to A17 and numbers in the range C7 to AB17.
How can I make the reference Search_Row dynamic, determined by the chosen Name?
Chris
Someday I'll know what I'm donig...damn!