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 |
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 |