Help - I need to rename multiple entries

  • Thread starter Thread starter perlaki
  • Start date Start date
P

perlaki

Hi all, any help with this will be much appreciated.

I'm running an online gig guide, and get sent a gig listings by a majo
ticket agent. Their club names don't match mine, so I need to renam
their club names to match my club ID numbers
e.g. if club name = 'Arches, Glasgow', rename to '107052004145012'

I've tried this

=IF((D1="Barfly @ Masque"),105092002142800,IF((D1="Barfly
Camden"),110112003124941,IF((D1="Barfly
Glasgow"),124112003165208,IF((D1="Carling Academ
Brixton"),110112003115536,IF((D1="100 Club"),110112003122503,IF((D1="9
Feet East, London"),110112003123753,IF((D1="Alexandra Theatre
Birmingham"),118112003121536"")))))))

which basically doesn's work, plus there's a limit to if statements.
have about 50 clubs to rename!!

Any ideas on the best way forward.
Cheer
 
Set up the names and their aliases in a table and use VLOOKUP to retrieve
the other value.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Bob, thanks for that. BUT, as a bit of a novice, I'm trying t
understand this VLOOKUP thing.

Do I create a new excel file, and place all the names and aliases i
that? And where do I place the VLOOKUP code? How would the code look
 
Hi, ok I've got it to work for one cell, or as many as I type into th
cells, but obviously the worksheet that the agent is sending me i
massive.

How can I copy and repeat this forumla down the page without the tabl
array moving? It seems to ascend in number as well!!
 
Back
Top