| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF function and validation list
=IF(c4="","",IF(isna(match(c4,summary!a5:a40,0))," Hotel","Operator"))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Shavey" wrote in message ... How do I clear the cell if the reference cell is empty? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation function that created from another drop down list | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Copy workbook- Validation function | Excel Worksheet Functions | |||
| Validation List and VLookup are ackting strange | Excel Worksheet Functions | |||
| Validation - List - Separate Worksheet | Excel Worksheet Functions | |||
Threaded Mode
