mardi 30 octobre 2018

EXCEL IF STATEMENT AND ISNUMBER SEARCH

I am basically trying to have multiple ISNUMBER and IF statement:

DESCRIPTION CATEGORY

ALL ACCESS -- NA
AMTRAK NRT -- TRAVEL
INDEED -- Recruting

So basically. if the word has "all" put NA, if the word has "amtrak" put travel, if the word has "indeed" put "recruiting"

I'm trying with this =IF(ISNUMBER(SEARCH("amtrak",D9)),D9,"train"), IF(ISNUMBER(SEARCH("all",D9)),D9,"t")

But it's not working. IT keeps give me error "value" or I tried this one =IF((AND(ISNUMBER(SEARCH("abm",B5)),B5,"don't know")),AND(ISNUMBER(SEARCH("all",B5)),B5,"don't k")) with same error.

Thank you

Aucun commentaire:

Enregistrer un commentaire