lookup specific value in a column and show it in a new cell

P

Piotr (Peter)

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
 
P

Pete_UK

Put this in the cell where you want the result:

=IF(ISNA(MATCH("08 2008",A$1:A$100,0)),"","08 2008")

Of course, you could put 08 2008 in another cell, eg D1, then you can
have:

=IF(ISNA(MATCH(D1,A$1:A$100,0)),"",D1)

Hope this helps.

Pete
 
P

Piotr (Peter)

Hi,
Thanks Pete. Fantastic.Works like a charm:)

Pete_UK said:
Put this in the cell where you want the result:

=IF(ISNA(MATCH("08 2008",A$1:A$100,0)),"","08 2008")

Of course, you could put 08 2008 in another cell, eg D1, then you can
have:

=IF(ISNA(MATCH(D1,A$1:A$100,0)),"",D1)

Hope this helps.

Pete
Click to expand...
 
Top