Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

HMIP  LDU
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:

HMIPID  WYLDU
1   
2   
3   
5   

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
add comment

2 Answers 2

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
add comment

Here's a really good tutorial on how to use VLOOKUP.

It could be useful for future reference, I know it helped me a lot recently.

Using Vlookup in Excel

share|improve this answer
add comment

Your Answer

 
discard

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.