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
|