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!
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!
