Hi,
I am trying to extract all data from a list based on 2 criteria. Eg, The first is an account number (in B1) and the second is a product code (in B8) and I am wanting to extract all order numbers for that account only, in the source data the account number is in column D, the product is in Column C and the data I want to extract is in column F. It is possible that there will be multiple orders..
Please can anyone help?
I am trying to extract all data from a list based on 2 criteria. Eg, The first is an account number (in B1) and the second is a product code (in B8) and I am wanting to extract all order numbers for that account only, in the source data the account number is in column D, the product is in Column C and the data I want to extract is in column F. It is possible that there will be multiple orders..
Please can anyone help?