#VALUE! Using Nested Search

F

Frank Kabel

Hi
try

=IF(ISNUMBER(SEARCH("70",B12)),"DC",IF(ISNUMBER(SEARCH
("43",B12)),"VM","RG"))
-----Original Message-----
Trying to in Cell C12 and Down:

=IF(SEARCH("70",B12)>0,"DC",IF(SEARCH("43",B12)
0,"VM","RG"))

Formula is returning All "DC"'s which have ***70** in string
But I'm getting the #VALUE! Not "VM"
Click to expand...
or "RG" in the case of ***43*** and All others..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas not calculating in some fields 1
IF AND VLOOKUP formula needed 1
Return Range Based on Cell Value 4
Using Sumproduct when some of the values are null 5
Lookup and average data in an unsorted list 1
Trying to collapse a table, what Function should I use? 3
Search Entire Sheet instead of 1? 4
Drop down list control value in vba 2

Top