Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup specific value in a column and show it in a new cell
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 On Sep 4, 9:23*pm, Piotr (Peter) wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup specific value in a column and show it in a new cell
Hi,
Thanks Pete. Fantastic.Works like a charm:) "Pete_UK" wrote: 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 On Sep 4, 9:23 pm, Piotr (Peter) wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup specific value in a column and show it in a new cell
You're welcome - thanks for feeding back.
Pete On Sep 5, 8:24*am, Piotr (Peter) wrote: Hi, Thanks Pete. Fantastic.Works like a charm:) "Pete_UK" wrote: 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 On Sep 4, 9:23 pm, Piotr (Peter) wrote: 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup to Show Empty Cell | Excel Worksheet Functions | |||
first cell in a column with a specific value | Excel Worksheet Functions | |||
Exclude specific cell from entire column | New Users to Excel | |||
show name when a cell has specific word | Excel Discussion (Misc queries) | |||
How can I do a lookup to a specific cell on multiple worksheets? | Excel Worksheet Functions |