Thread: how do I insert a cell based on its match with an adjacent cell?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cell?

If your headings are in A1:C1 and sub-headings in A2:C2

If you want the appropriate sub-heading to appear in E11, for instance,
when you put one of the headings in E10 then one way would be to use
this formula in E11

=HLOOKUP(E10,$A$1:$C$2,2,0)

You can copy this formula along the row


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503512

Reply With QuoteReply With Quote