Hi. I have a question re xlookup or filter.
I have 2 workbooks, Master and Result. Master contains :-
Type / Desc / Qty
Results contains a unique List of the Type (from Master) and a dropdown to lookup to this.
Once a Type is selected in the dropdown I need to go to Master to return the matching items from the 3 columns. There will be multiple duplicates in Type.
Currently I am using Filter to do the look up which means I have to do it for each of the 3 columns (see below).
=FILTER('[Master.xlsx]Types'!$A:$A,B1='[Master.xlsx]Types'!$A:$A,"not available")
=FILTER('[Master.xlsx]Types'!$B:$B,B1='[Master.xlsx]Types'!$A:$A,"not available")
=FILTER('[Master.xlsx]Types'!$C:$C,B1='[Master.xlsx]Types'!$A:$A,"not available")
Is there a way I can look up to column A (Type) and return the 3 columns to the Result workbook, as I say there will be multiple items to return as Type is not unique ?
I am a novice at excel so if possible an example would help greatly.
I have 2 workbooks, Master and Result. Master contains :-
Type / Desc / Qty
Results contains a unique List of the Type (from Master) and a dropdown to lookup to this.
Once a Type is selected in the dropdown I need to go to Master to return the matching items from the 3 columns. There will be multiple duplicates in Type.
Currently I am using Filter to do the look up which means I have to do it for each of the 3 columns (see below).
=FILTER('[Master.xlsx]Types'!$A:$A,B1='[Master.xlsx]Types'!$A:$A,"not available")
=FILTER('[Master.xlsx]Types'!$B:$B,B1='[Master.xlsx]Types'!$A:$A,"not available")
=FILTER('[Master.xlsx]Types'!$C:$C,B1='[Master.xlsx]Types'!$A:$A,"not available")
Is there a way I can look up to column A (Type) and return the 3 columns to the Result workbook, as I say there will be multiple items to return as Type is not unique ?
I am a novice at excel so if possible an example would help greatly.