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
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?