Matching Three Inputs to Determine Fourth

[gflat65]

Hello all. Newbie to the site and have a question.

I've added drop downs to three columns with the valid values for user input. Once the user has chosen the inputs, I'd like a function that matches those three inputs and returns the corresponding value in a fourth column.

I started with an Index/Match, but I don't think I'm on the right path.

A B C D
(Part#A) (Part#B) (Part#C) (Value I want returned when A, B, and C are selected)

The matrix is set up as four columns on a separate worksheet within the workbook, where the fourth column is the desired output from the selection of the three inputs.

I've abused Vlookups for years, but this is my first attempt at an Index/Match. What I have is below (not currently working, as I think is to be expected given that my approach may not be at all correct).

A2:D43 is the range of data for the four columns. A2:A43 is Part A, B2:B43 is Part B, C2:C43 is Part C, and D2:D43 is the value I want returned when the first three are matched.

=INDEX(Matrix!$A$2:$D$43,MATCH('Input Page'!A2,Matrix!$A$2:$A$43,0),MATCH('Input Page'!B2,Matrix!$B$2:$B$43,0),MATCH('Input Page'!C2,Matrix!$C$2:$C$43,0))

TIA.

 

[Gary McMaster]

Maybe you could concatenate your A, B & C inputs and do the same in your matrix. Then you would only need 1 lookup.

Gary

 

[gflat65]

That works like a charm.

Thanks for the advice. Have a good day.

 

[gflat65]

Okay, I've got another question the same item above. I've been asked to limit the drop down boxes based on the first entry.

From above:
(Part#A) is entered via drop down. The drop down box for (Part#B) would then be limited to a drop down that only allows for the valid inputs for Part#B based on the entry in Part#A, instead of allowing the user to see all allowable Part#B's (across the range of the Part#A drop down). I'd then do the same for Part#C, based on the selection in Part#A.

Does that make sense? Can I do that?

TIA.

 

[T. Valko]

Okay, I've got another question the same item above. I've been asked to limit the drop down boxes based on the first entry.

From above:
(Part#A) is entered via drop down. The drop down box for (Part#B) would then be limited to a drop down that only allows for the valid inputs for Part#B based on the entry in Part#A, instead of allowing the user to see all allowable Part#B's (across the range of the Part#A drop down). I'd then do the same for Part#C, based on the selection in Part#A.

Does that make sense? Can I do that?

TIA.

See if this helps...

http://contextures.com/xlDataVal02.html

 

[gflat65]

Once again, that's got me going.

Thanks again. Have a good day,

gflat

 

[T. Valko]

Once again, that's got me going.

Thanks again. Have a good day,

gflat

You're welcome. Thanks for the feedback!