Do you want an individual result, or a table of results? Can a question have
an answer for more than one category (animal?)?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darin Kramer" wrote in message
...


Hi there,

in Cells a1:z1 i have a list of items, say dogs, cats, mice etc.. (all
unique)
Cells a2:a100 question numbers (questions 1 to 100)
Body of the table (ie a1:z100) contains the results for the questions

I want to be able to extract a result.
For example what was answer for question 53 for Cats

Sumproduct would work if it had to sum, but I dont need to.

Is it a combination of h and v lookups?

Appreciate assistance!!

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***