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 sheets in an excel file. In the first sheet I have a column "types", and in the second sheet there are more information to different "types". For each row, I want to have excel search the type, which is specified in, say, the first column, in the "type sheet" (sheet 2) and to include columns from this sheet to the rows in my first sheet.

I was thinking this could be done maybe with VLOOKUP, but didn't find out how to get this to work.

share|improve this question
1  
To improve the chances of getting answers, and the quality of the answers, please edit your questions to include What version of Excel you have. Also tell us what you have tried so far. –  CharlieRB Dec 17 '12 at 13:32

1 Answer 1

up vote 1 down vote accepted

How about this? Type this into the top cell and then copy and paste it down the column =VLOOKUP(A2,Sheet2!$A$2:$B$4,2)

(You will have to replace the column letters and column index with the right ones.)

share|improve this answer
    
You're right, the thing may first attempts did not work was that the fixed $'s after Sheet2! seem to be crucial for VLOOKUP to work –  Yo Ludke Dec 18 '12 at 8:41

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.