View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Piotr (Peter)[_2_] Piotr (Peter)[_2_] is offline
external usenet poster
 
Posts: 27
Default lookup specific value in a column and show it in a new cell


Sorry but I couldn't find this. I need a formula that finds a date (shown as
text) 08 2008 in range e.g. A1:A100 and if found, this should be placed in a
new cell of other column. If not found then the cell should remain blank. I
have tried if function but didn't work for me.
Any help appreciated.
Piotr