Re: is it possible to do lookup with cells containing tildes "~"?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes Tom I was able to find the titles using "~~" - but when it comes to
thousands of lines I don't think I can do it manually :-(

Please see my reply to biff for more details....many thanks anyway

"Tom Ogilvy" wrote:

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" <StevenVegeta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8579FB4-D716-42D3-8E58-BB896FF69623@xxxxxxxxxxxxxxxx
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" <StevenVegeta@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C0126AF2-DDC7-47D0-BA2A-FC8A65BED0AA@xxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: is it possible to do lookup with cells containing tildes "~"?
    ... titles only), and the other one is a master file which has all titles and ... I'm trying to use vlookup to get the stock availability for those selected ... DVD titles, but then I found out that vlookup can only return the stock ... Is there any way that Excel's lookup can match my titles with tildes ...
    (microsoft.public.excel.misc)
  • Re: is it possible to do lookup with cells containing tildes "~"?
    ... titles only), and the other one is a master file which has all titles and ... I'm trying to use vlookup to get the stock availability for those selected ... DVD titles, but then I found out that vlookup can only return the stock ... Is there any way that Excel's lookup can match my titles with tildes as ...
    (microsoft.public.excel.misc)
  • Re: LINYC and/or Barcelona on Blu Ray?
    ... titles will see a release on blu-ray as both titles were filmed in HiDef. ... You can pretty much expect music/concert titles that were filmed in HiDef ... "Red Rocks" (which is languishing unreleased even on dvd for a bunch of ... holdout on the blu-ray format, Universal (they've only released titles on HD ...
    (rec.music.artists.springsteen)
  • Re: Safecracker? Overrated? WDYT?
    ... Stacy used to like ToM a lot, ... some of the pricier titles, I find a lot of games in the ToM range ... but what is the hype? ...
    (rec.games.pinball)
  • Re: Rubicon - "You Can Never Win" (SPOILERS)
    ... I think someone on the newsgroup suggested that the clover recipients ... If that were the only consequence, Gerald or Tom ... was a kid) He had to know ahead of time along with making that DVD ... Maybe it was for being opposed to killing David. ...
    (rec.arts.tv)