Using lookup with wildcard

[littlefalco]

Hello,

I am new to excel, and wish to know how I can use Excel lookup with
wildcard? I have a number of devices that people call by different
names but there is a word that is common to all - "domain"

For example :

AD domain controller
domain controller
WINS domain controller
etc

I want to reclassify this as simply domain controller in a list of
data.

Please can some one help?

 

[Bob Phillips]

=INDEX(B1:B100,MATCH(TRUE,(ISNUMBER(FIND("domain controller",A1:A100))),0))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

Perhaps

=VLOOKUP("*domain controller*",A1:B100,2,0)