Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread
 
  • Post
  • Reply
The Mechanical Hand
May 21, 2007

as this blessed evening falls don't forget the alcohol
Originally, mistakenly, posted in the general programming thread, but anyway...

Need some help with an excel problem I've come across.

I have a drop down list with names of cities in it.

I want to set this up so when you pick a city from that list another field will populate with an address associated with that city. I know it has to do with formulas and all that but I am totally lost. Any help?

* # ¿ Dec 9, 2010 18:58
  • Quote
Adbot
ADBOT LOVES YOU

# ¿ May 7, 2024 00:09
  • Quote
The Mechanical Hand
May 21, 2007

as this blessed evening falls don't forget the alcohol
I have two columns each with a list of e-mails.

I need to find the e-mails that appear in BOTH Column A and Column B and eliminate the rest.

How can I accomplish this? I'm retarded with excel.

So in short, I want to keep duplicates, and delete any e-mail in Column A or B that doesnt' have an exact match in the other column

* # ¿ Mar 29, 2011 16:29
  • Quote
The Mechanical Hand
May 21, 2007

as this blessed evening falls don't forget the alcohol

ZerodotJander posted:

I would do a VLOOKUP from Column A into Column B and keep all the ones that don't error out.

So in cell C1, =VLOOKUP(A1, B:B, 1, False) and fill down. This will look in Column B for the value in A1. If it is found, it will just reprint the value again. If it is not found, it will produce an error message.

drat! Thanks a million. Out of simple curiosity how does this work out on the technical side? Like I said, I'm completely retarded with this sort of stuff so I'm not sure what's going on behind the scenes here.

* # ¿ Mar 29, 2011 17:06
  • Quote
  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply
The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread