Thanks Biff - I'm matching some titles like

1. New DVD ~ Rocky Series
2. New DVD Boxset 3 discs - First Blood part 1 2 3
3. The lord of the rings ~ The return of the king DVD

I have 2 files (obtained from my colleague) containing these titles - and I
need to get the matching ones.

Many Thanks.
Steven

"Biff" wrote:

Are you looking up specifically just the character ~ or ?, like this:

.........D..........E
1......x...........1
2......y...........2
3......~..........3
4......?...........4

Give some examples of what your lookup_values are and what the titles are.

Biff

"Steven Vegeta" wrote in message
...
Hi there,

I've been using vlookup on my tables and just discovered that the lookup
actually failed when the cell contains one or more tildes "~" (well never
really use a tilde for it's special purpose before).

Is there any way that Excel's lookup can match my titles with tildes as
well
? if not then I guess I'll have to replace all my tildes in my cells to
other
signs......probably hyphens.

Many Thanks in advance!

Steven Vegeta