| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
look for a pipeID in a column and returns "broken" result
I have a column of pipeID (1400 IDs).
I have a column of Target pipes. (78pipe IDs) I want a command to look Target pipes in pipeID and writes broken in front of it if it finds in pipeID column and leave empty if it couldn't find. I think I have to combine Hlookup and if command but I couldn't recognize how. Will be happy if there is any help. -- Rasoul Khoshravan Azar Civil Engineer Osaka, Japan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use =countif to generate returns from more than one column | Excel Discussion (Misc queries) | |||
| Automatic enter that returns you to column A in Excel | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
