I am trying to fill in data on sheet "A" from sheet "B". The data will be chosen from 2 different pull downs,
So sheet A has pull down list 1 and pull down list 2.
They are both linked to data on sheet B.
I need a way to look a the data in the 2 pull downs on Sheet A and bring in all the data from sheet B with those 2 pieces of data into a list on sheet A.
I`ve added images of the sheets.
So sheet A has pull down list 1 and pull down list 2.
They are both linked to data on sheet B.
I need a way to look a the data in the 2 pull downs on Sheet A and bring in all the data from sheet B with those 2 pieces of data into a list on sheet A.
I`ve added images of the sheets.