VLOOKUP?

[saranat]

I need to know how I can access a database of names which are not sorted and occur more than once in the list. I need to do this without VBA.
I prefer to use VLOOKUP or INDEX /Match
Thanks in advance
saranat

 

[Tazguy37]

Please provide a small sample of your sheet, if possible, or at least the layout of your work, what valus you're looking up, and the return values. Thanks!

 

[PA HS Teacher]

What do you mean by "access a database"

Would it be good enough to use autofilter? That way you could see all the entries for one name?

 

[saranat]

I have several worksheet tabs in an Excel workbook.
Sheet 2 is my employee "database" for which I enter their lastnames, firstnames, id number, etc, each time a work order is given out.
the other sheets will have a list of the same names with different work routines.
Sheet 1 is a summary sheet that i use to look at what each employee is doing workwise. So I'm entering a Last name on sheet one and i use VLOOKUP to find the occurence of the last name(For example Smith) in sheet 2, the "database" and also in the other sheets so that i can summarize diffent fields from other sheets onto the summary sheet.
However, I need to find each occurence of the same lastname from the "database"along with the various respective fields from other worksheets.
Autofilter won't work.
It can't be done in VB.That's the thing.
Has that helped clear up things or have I made it worse?
saranat