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.

So sheet 1 is currently empty and on sheet 2 i have the following:

Column A Column B Column C Column D

Hobbies travelling swimming Jogging

What do i have to do so that if i write Hobbies in Column A of Sheet 1, Columns B, C and D of Sheet 1 are filled in automatically with the contents of Columns B,C and D of Sheet 2?

share|improve this question
    
Welcome to Superuser. This may sound trivial, but I just want to clarify your question; you are asking for sheet1 to reflect what you put in the columns of sheet2? Or are you wanting the data on sheet2 to be the first sheet of the workbook? –  CharlieRB Jun 13 '12 at 11:45
add comment

2 Answers

Try this

Put this formula in cells B1, C1, D1 of Sheet1, then copy down as far as needed

=IFERROR(VLOOKUP($A1,Sheet2!$A:$D,COLUMN(),0),"")
share|improve this answer
    
Good answer (more versatile than @James' solution) - shame OP has not bothered to accept it. –  pnuts Dec 5 '12 at 9:27
add comment

=if(a1 = "Hobbies", b1:d1 = Sheet2!b1:Sheet2!d1,"")

What we are saying is cell a1 (column a, row 1) = Hobbies then cells b1 through d1 = the cells b1 through d1 of Sheet2 otherwise leave it blank.

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.