Lookup Value and Return Column Heading


E

eb

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
 
Ad

Advertisements

T

T. Valko

Some of the values in the table data have leading 0s. Are these formatted
numbers or TEXT entries? Are there any duplicate values in the data table?
 
E

eb

Thanks for the responses
No duplicates and all are formatted as numbers.

The first formula post will not return the value 100% of the time. The
lookup value will change and may or not be the max/min number in the column.

Thanks
 
T

T. Valko

The first formula post will not return the value 100% of the time.

What is the *exact* location of the table in cell references? Like: it's in
the range G10:L18.
 
Ad

Advertisements

E

eb

Thanks all -- Was able to return the column heading with sumproduct.
=sumproduct((A85:F85)*(A86:F94="my lookup value"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top