Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have two data tabs for survey responses - the first shows the full set of exepcted responses an which office they are from

1     Leeds
2     Leeds
3     Leeds
4     Leeds
5     Wakefield

The second those that have actually responded and I need to get their office location next to the ID:


I have hundreds and will be doing this a lot so any help appreciated!

share|improve this question
vlookup ....... – smirkingman May 29 '12 at 14:44
@smirkingman In order to help the entire community of Superuser, when posting a comment, please explain yourself. When giving an answer, post it in the "Answer" area below and please give some detail to help anyone who reads it. Just posting a single word does not necessarily help. Thanks. – CharlieRB May 29 '12 at 15:23

Here is how VLookup should be used in your case:

enter image description here

share|improve this answer
Thank smirkingman - worked a treat and now I'll go and learn more about Excel formulae! – Kev B May 29 '12 at 16:09
You're welcome. It's considered polite to accept the best answer with the tick sign on the left. It'll help your reputation too >:-) – smirkingman May 29 '12 at 20:29

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .