Cell References & Index & Match

[Charlinda]

Good Day,

I'm hoping the following is making sense...

My current workbook looks like:

Sheet 1 - Front Page
Sheet 2 - Client Data
Sheet 3 - Product Information
Sheet 4 - ActiveData

Sheet 1 - Front Page (includes the following fields)

Next Available Client #: 1 (Formula: =MAX(ClientData!B1:B1000)+1)

Client #: (Input whatever number shows above)
Client Name:
Client Surname:
And other client information.

What I want to do is reference the client name (done with dropdown list) and the client number assigned to it and then associate which products the clients have.

The formula I had and which works on another workbook,is =INDEX(ClientData!A2:U1001,MATCH(ActiveData!C2,ClientData!A2:A1001),MATCH("Client #",ClientData!A1:U1,))

The ActiveData sheet has the following fields:

No ---Description ---Data ---Final
1 ----Client #---------------The INDEX formula was pasted here

The Data Field used to show the amount of clients entered and line up the client's "unique" number in the Field column.

Needless to say, I don't know if I'm missing something, but I'm not getting this to work. I have been able to successfully create a dropdown list showing the client's I have entered, but don't have any idea of how to proceed to link the assigned client number to the client name and then add the products that they have to reference both those criteria.

This will allow me to in my Product Information sheet do filters on any one client and see what products they have and such.

I do hope you will be able to assist!

Thanking you kindly,
Charlinda <!-- / message --><!-- edit note -->