Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.