| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with Excel 2000 text-related functions
How do I search a range of text cells and return value(s) based on my findings?
From C18, I want to search C3:C14, said cells sometimes containing names, to see if one particular name is there. If it is, I want to leave C18 blank. If it isn't, I want to insert the name in C18. I've tried IF multiple ways and it either returns "FALSE" or "#VALUE!". Help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000, RAND and IF functions do not work together for me | Excel Worksheet Functions | |||
| Excel 2000 - Formulas and Functions | Excel Discussion (Misc queries) | |||
| EXCEL 2000 - COPY & PASTE FUNCTIONS! | Excel Discussion (Misc queries) | |||
| Extend Rows and related formula downwards using functions not macros | New Users to Excel | |||
| Excel 2000 Functions | Excel Worksheet Functions | |||
Threaded Mode
