View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default is it possible to do lookup with cells containing tildes "~"?

If you wanted to find

New DVD ~ Rocky Series

in the sheet, using Edit=Find, you would use

New DVD ~~ Rocky Series

You would put two tilde's in for the search target.

--
Regards,
Tom Ogilvy


"Steven Vegeta" wrote in message
...
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