And since the OP is matching on a name, I would think that he would want an
exact match.

=IF($A$1="","",VLOOKUP($A$1,Sheet1!$A$1:$J$118,COL UMN(B1),False))




Mike H wrote:

Maybe a bit better

=IF($A$1="","",VLOOKUP($A$1,Sheet1!$A$1:$J$118,COL UMN(B1)))

Mike

"Mike H" wrote:

Jeff

Your data on sheet 1 colmna A - J

Enter a name in a1 of sheet 2
Put this in b1 of sheet 2 and drag right 9 columns

=VLOOKUP($A$1,Sheet1!$A$1:$J$2500,COLUMN(B1))

Mike

"Jeff" wrote:

I have inherited a HUGE spreadsheet that probably needs to be converted to an
Access Database.

However, I have been tasked with making the info retrievable in its present
format.

Please give me suggestion for the following scenario:


10 columns/labels: Employee, Name, location, id#, Rating, etc.

2500 rows or records.

I would like to enter the employee name on a separated spreadsheet, and have
all of that employees records, or rows, displayed.

Thank you!!

Jeff

--
Jeff

--

Dave Peterson