Question on how to do a lookup

spartan1685

New Member
Joined
Jul 18, 2007
Messages
3
hey all,
I am trying to figure out how to do this one part of my excel sheet.
I have roughly 5k in rows containing unique info. I assigned a unique letter to each group ie aa, b, ccc, etc. and each name in the group gets a numerical value 1, 2,3, etc
I first ask for the user to input a department then input a group.
If they give me that information how can i lookup in that particular group to display user names. so say in group x there are 5 names and i want to give the user a drop down to let them choose one of those 5. any thoughts?
i greatly appreciate help in advance...
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

spartan1685

New Member
Joined
Jul 18, 2007
Messages
3
if this helps basically in sheet 1: G7 the group and divsion concatenated so it looks like this: waterdivtreatgroup, in sheet2 where i house all of the data this name is in the a column for any individual in this group.. I need to create a drop down off of this name waterdivtreatgroup so it can display the listing of names under this term.
i really dont even know how to explain / start this problem very well...
currently i have a countif and i know how many times the object appears in sheet2. now i need to actually lookup the names under that object...or if it was possible to get either the start or end cell location i could do the drop down off of those i suppose...
 

dr_shivan

Active Member
Joined
Jan 3, 2005
Messages
298
You can do a filter and filter those entries which is the most simplest way to do
 

Forum statistics

Threads
1,181,055
Messages
5,927,861
Members
436,573
Latest member
CMR237

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