Thread: how do I insert a cell based on its match with an adjacent cell?
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gabbon
 
Posts: n/a
Default how do I insert a cell based on its match with an adjacent cel
Thank you so very much (how do you find this stuff--I looked all over help
and could not locate it)
The formula:

=HLOOKUP(TEXT(E10,"dd-mm"),TEXT($A$1:$C$2,"dd-mm"),2,0)
confirmed with CTRL+SHIFT+ENTER

Was perfect, and does as I sought (brilliant!)
Thanks again

Reply With QuoteReply With Quote