PDA

View Full Version : Find X Value and Past Y in column Beside



Prospec
03-10-2006, 12:29 PM
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
03-10-2006, 01:09 PM
Sounds like you need to use VLookUp. Can you attach an example of your data?

Prospec
03-10-2006, 01:23 PM
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.


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