Thread: how do I insert a cell based on its match with an adjacent cell?
View Single Post
  #9   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?

Based on my previous example perhaps

=HLOOKUP(TEXT(E10,"dd-mm"),TEXT($A$1:$C$2,"dd-mm"),2,0)

conformed with CTRL+SHIFT+ENTER


--
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