VLOOKUP?

saranat

New Member
Joined
Jan 26, 2005
Messages
15
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
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
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

New Member
Joined
Jan 26, 2005
Messages
15
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
 

Forum statistics

Threads
1,147,669
Messages
5,742,520
Members
423,736
Latest member
dracula cyrus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top