Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If function?
Newbie question...I'm looking for the formula that will report the value that
I want in column B. I guess wildcards must nbe used. I tried =IF (A1 = "*Catalog*", "Catalog", IF(A1 = "*Stock*", "Stock")) A B Stock - Rock Stock Catalog - Indie Catalog Catalog - Rock Catalog Stock - Indie Stock Thanks for your help. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |