Posted by Duane Kennerson on November 02, 2001 12:39 PM
I have a range that is 6 columns wide by 1000 rows. It contains information on several employees by day so one employee could be in the range several times depending on if they did work on that day or not.
The first column of the range contains the employee number and the following 5 rows contain their production information. I want to have a cell where someone could enter and employee number and only the information on that employee would be displayed from the range.
(i.e. if someone typed in employee # 29647, excel would look through the range and find all of the information for employee # 29647 and copy it to another area for further processing)
Is this a vlookup thing? Can anybody help me?
Thanks in advance...