VLOOKUP question

[Cacoe]

I can't get a VLOOKUP to work. VLOOKUP may be the incorrect function to
do what I want if what I want is even possible.

_The_Problem:_
I have input the answers to an opinion poll. Individuals rank their
opinions 1 thru 10. There are 100 possible choices, but a respondant
can only choose their top 10 and rank those ten accordingly.

Column A=the possible opinions.
Columns B-Z=the respondants on Row 1 and the 100 possible choices on
Rows 2-101.

So, B1 is the text "Arnold". Somwhere between B2-B101 will be the
numbers 1-10 and 90 empty cells.

On a seperate sheet I want to be able to put a respondants name with
their 10 repsonses beneath them from Column A. In order would be nice
as well.

Is this even possible.

Thanks for any help.

 

[Guest]

I am not totally sure what you are trying to accomplish, but it sounds like
you will need to use an HLOOKUP instead. Use the name of the respondent as
your lookup name. If you didn't know, an HLOOKUP works the same way as a
VLOOKUP but instead of pulling the number of a column, it pulls a row.

 

[Biff]

Is this what you had in mind?

http://img360.imageshack.us/img360/5369/samplegg4.jpg

Biff