What are the "*" and the & for?

The "*" are wildcards and the "&" is the concatenation operator. When you
see the "&" think of it as the word AND.

This is what it means:

"any character or characters" & this is it & "any character or characters"

--
Biff
Microsoft Excel MVP


"johnrb7865" wrote in message
...
That worked, thank you. Can you explain to me how the section "*"&D1&"*"
works? What are the "*" and the & for?

Thanks,
John

"T. Valko" wrote:

...........A..........B
1........5........not his stuff
2........2........some more junk
3........1........yes, this is it
4........6........blah blah blah
5........9........I need a break

Lookup "this is it"

D1 = this is it

=INDEX(A1:A5,MATCH("*"&D1&"*",B1:B,0))

Result = 1

--
Biff
Microsoft Excel MVP


"johnrb7865" wrote in message
...
Hi, I need to search a range of cells for a piece of text, not an exact
match
of the whole string, but just some words. Then, when it finds that I
need
to
pull the information same row, 1 column to the left. I have
descriptions
in
the 2nd column and codes in the 1st, and when it finds a piece of the
description I need the code.

Any help would be great.

Thanks,
John