Find X Value and Past Y in column Beside

[Prospec]

Using Windows XP and Excel 2003 SP1.

I need to write formula to find value X in sheet B and past Y value in the same row and column beside of where X value was found in sheet B. Values X and Y are in sheet A.

[Jacob Hilderbrand]

Sounds like you need to use VLookUp. Can you attach an example of your data?

[Prospec]

Hello Jake,

Vlookup will not work for me b/c this is a dynamic sheet (called Review) where a user pulls from a drop down list a Country and it shows results and questions about those results. Then he answers the questions in cells F4, F9, F14, F19 and F24. The questions are saved in a sheet called Answers. In this sheet the there is a row for each country it's questions and another row for the answers. I would like to find the country selected in Review and save the corresponding Answer to it's questions in the Answer sheet.

[vba]
Lookup Value Country Q1 Q2 Result
JamaicaQuestion Jamaica Why? How? Question
JamaicaAnswer Jamaica Anwser
HaitiQuestion Haiti When? Where? Question
HaitiAnswer Haiti Answer
[/vba]