Thread: Numeric reference of column. Data Grab ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
ShaunM
 
Posts: n/a
Default Numeric reference of column. Data Grab ?

Hi

I think this will work

=INDEX($C$1:$AH$1,,MATCH("x",C2:AH2,FALSE))

But it looks like PinMaster beat me to it

Regards
Shaun


--
ShaunM
------------------------------------------------------------------------
ShaunM's Profile: http://www.excelforum.com/member.php...o&userid=18610
View this thread: http://www.excelforum.com/showthread...hreadid=498080

Reply With QuoteReply With Quote