Using lookup with wildcard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

littlefalco - 10 Dec 2006 22:46 GMT

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?

Reply to this Message

Bob Phillips - 10 Dec 2006 22:51 GMT

=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.

Signature

---
HTH

Bob

(change the xxxx to gmail if mailing direct)

> Hello,
>
[quoted text clipped - 13 lines]
>
> Please can some one help?

Reply to this Message

daddylonglegs - 11 Dec 2006 00:04 GMT

Perhaps

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

> =INDEX(B1:B100,MATCH(TRUE,(ISNUMBER(FIND("domain controller",A1:A100))),0))
>
[quoted text clipped - 17 lines]
> >
> > Please can some one help?

Reply to this Message

Rate this thread: