I have two sheets in excel. Sheet #2 has info in A1 through Af, 400 items
listed down, all items have a unique number. When I enter that number in
sheet one how do I get it to pull all the info from sheet 2 onto sheet 1?