Thread
:
How to return column header contents when a cell in the column has a value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
How to return column header contents when a cell in the column has a value
Hi,
Am Tue, 4 Aug 2015 20:10:02 -0700 (PDT) schrieb
:
For example, 7889STAPLES would return the result "61140"; 1502CDW would return "61065"; and so on.
try:
=INDEX($1:$1,MATCH(1,ISNUMBER(INDIRECT(MATCH("7876 STANDARD",$A$1:$A$100,0)&":"&MATCH("7876STANDARD", $A$1:$A$100,0)))*1,0))
or
=INDEX($1:$1,MATCH(1,ISNUMBER(INDIRECT(MATCH(A5,$A $1:$A$100,0)&":"&MATCH(A5,$A$1:$A$100,0)))*1,0))
and enter these formulas with CTRL+Shift+Enter
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch