You may want to explore the INDEX and MATCH worksheet Functions
This site has some good info:
http://www.contextures.com/xlFunctions03.html

tj

"Mike" wrote:

I have a data validation list in cell (A1) and another list in cell (B1). I
would like to select from the list in cell (A1) and then select from the list
in cell (B1) and have the results of both lists point to another specific
worksheet defined by the results in the two lists all within the same
workbook. Is that possible?