Lookup Value and Return Column Heading
=INDEX(A1:B1,MAX(INDEX((A2:B4=12)*COLUMN(A2:B4),)) )
"eb" wrote:
Need formula to lookup a value from a table and return the corresponding
column heading.
For example, I would like to look up the value 12 and have the formula
return 2222.
Example of table - Table is 6 columns x 9 rows. No row headers just column
headers.
A B
1111 2222
1 06 07
2 09 10
3 11 12
Appreciate the help
|