Looking to auto populate a list based on 2 criteria match

[ExcelUser678]

Hello! I'm looking to create a list based on data from a second tab. I'd like the list to be populated in Sheet 3 with data from Sheet 2, column B. My parameters would be if column A on Sheet 2 matches Cell B2 on Sheet 1 and Column C on Sheet 2 matches specific text (i.e, Vehicles).

 

[alansidman]

Suggest you use XL2BB to upload a sample worksheet 8-15 records that is representative of your data and then mock up the solution so we understand exactly what you are looking for. No pictures as we cannot manipulate data in a picture.

 

[Peter_SSs]

Welcome to the MrExcel board!

Try this in Sheet3 (adjust row ranges if required)

=FILTER(Sheet2!B1:B1000,(Sheet2!A1:A1000=Sheet1!B2)*(Sheet2!C1:C1000="Vehicles"),"")

 

[ExcelUser678]

Welcome to the MrExcel board!

Try this in Sheet3 (adjust row ranges if required)

=FILTER(Sheet2!B1:B1000,(Sheet2!A1:A1000=Sheet1!B2)*(Sheet2!C1:C1000="Vehicles"),"")

Peter, this worked perfectly! Thank you!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.