You can use a vlookup.
Instructions:
http://www.officearticles.com/excel/...soft_excel.htm
Tutorial:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Kerry" wrote in message
...
I have 2 sheets in excel... I need to do a query that says IF a number is
input into a cell (in a large array) in sheet two, THEN the name that
corresponds in that row will be input into a cell in sheet one.
ARGH PLEASE HELP!!!
Thanks,
KAM