Lists depending on ID

F

Fester

I have a spreadsheet (a supply list), what I want to do is have a list
populated in the spreadsheet depending on the ID number selected.

Client 123 can only order Item A, Item B, and Item C.

Client 456 can only order Item A, and Item C.

etc.

I know I can do dependant lists, but all I want is for the cells to
populate with the list of items available.
 
O

Otto Moehrbach

Fester
You need to furnish a bit more information for someone to give you some
meaningful help with this. Specifically, what is the layout of your data?
By this I mean:
What is in Column A?
What is in Column B?
Etc

I gather that one of the columns holds the ID number. Which column?
You say that you want a list extracted from the overall data. Be specific
with what data (columns) you want extracted. Finally, where do you want
this list placed and what do you want to happen with the list that was
placed there before? HTH Otto
 
F

Fester

OK, so here's what I want to do.

User selects Acct # 123456 in A1

In cells A6 - A10, you have blank cells. Once the user selects the
acct #, cells A5 - A10 would then be populated with the following:


A6 Gloves
A7 Routine Bags
A8 STAT Bags
A9 Tubes
A10 Supply Req

If another acct is selected the list would be different.

I have setup (I think this is the way to do it), that has Z1 - Acct #,
then, Z2 Item1, Z3 Item2, Z4 Item3 etc.

Does this help?

Also, each time the acct is selected, the list will change (be
overwritten).

I'd like to try to do this without macros as it's going to a client's
site and I don't know if they allow them.
 
O

Otto Moehrbach

Fester
You gave a good explanation of the destination, but not of the source.
I gather that you have data somewhere that lists all the ID numbers and the
associated 5 items that go with each ID number. Not knowing any more than
that about the source, I suggest you look up the VLookup function in Help.
From what you say, VLookup will do what you want. Post back if this doesn't
do it for you and include detail about the source data. HTH Otto
 
F

Fester

Yes, I have a table with the information.

Now, with Vlookup, which option would be better?

Option A:

Client ID Item A Item B Item C
123 Bricks Shovels Hammers

Option B:
Client ID: 123
Item A: Bricks
Item B: Shovels
Item C: Hammers

Sorry for the little info, I'm trying to figure out how to word and
have it make sense.
 
O

Otto Moehrbach

I take it that you are talking about the destination. It wouldn't make any
difference. You would write a VLookup formula in each of the cells in which
you want data (Bricks, Shovels, Hammers). HTH Otto
 
F

Fester

Excellent, I ended up using Hlookup and it worked. Thank you for the
guidance.

I appreciate the help.

Have a great day.
 
Top