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

[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

 

[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

 

[Piotr (Peter)]

Hi,
Thanks Pete. Fantastic.Works like a charm

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

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Hi,
Thanks Pete. Fantastic.Works like a charm







- Show quoted text -