Formula/Macro to match 2 values and return multiple results?

[mkron]

Hello there,

Basically, I am trying to create an excel sheet that will take in options for a product and generate dimensions, a description, and possible drawings based on those inputs to have consistancy across all users.

I was successful with the dimensions and descriptions but am struggling with the list of drawings. I have created TableL (on sheet "DWG_MAIN" which has 3 columns (DWG, LH, RH). I am trying to reference 2 cells (C15 & D15) from "SHEET_L".

if C15 = TableL[LH] and D15 = Table[RH]
then create list of drawing numbers associated with those from TableL[DWG] on SHEET_L.


I know there is the possibilty of using INDEX MATCH but I am not very familiar with that function.


I would like to get this done with a formula or image-assigned macro and not with the autofilter option inside Excel.


Thanks in advance for helping out!