I have a workbook that I'm trying to pull information from into a different workbook based on different product code i use the formula below to pull the info however when i drag it down to pull through the next code if there is more than one code then it will return #spill is there an easy way to pull so that all line with product 1 show then underneath it shows product 2 etc
This is the formula I'm using
=FILTER('[Review LIbrary.xlsx]Sheet1'!$A:$D,'[Review LIbrary.xlsx]Sheet1'!$A:$A=Sheet2!B2)
This is the formula I'm using
=FILTER('[Review LIbrary.xlsx]Sheet1'!$A:$D,'[Review LIbrary.xlsx]Sheet1'!$A:$A=Sheet2!B2)
Last edited: