Question test

[Ingolf]

Hey!
I have a sheet with 500 questions, after every question is a blank row for answers. In the same workbook I have 5 sheets with question and answers.
In that sheet with 500 questions I need to put the answer from the other sheets. I mention that every question from first sheet is identical question (and answer) in the other sheets.
Hope you understand what I want.
Thanks in advance for any help.

 

[cjcobra]

First, I would move all the answers to all the questions next to the question. You can do with with some IF statements.

I would do a couple VLOOKUP formulas with an ISERROR in front when it doesn't find the answer on that sheet. Basically =if(iserror(VLOOKUP(your question, sheet 2, 2,0)...

 

[Ingolf]

Thanks for answer but I think I don't follw you