Multiple If & Vlookup

Hello Friends:

I would need your help to know a function which can do both multiple ifs and vlookup together.

Attached is a file which shows the data in "Raw Data" worksheet. I would like a formula to be added to the other 2 worksheets named 1A and 2A such that the data pulls in automatically through Raw Data.

This is how it will work. I would like the formula to first look and see if column 1 has "1" in it and column 2 has "A". If yes, then it should do a vlookup and pull up all the columns into worksheet 1A. I created 2 scenarios and 2 worksheets. I would have more such scenarios to create so would need your help with the formula which I can use.

I filled in worksheet 1A as a sample of the data result I am looking for. I am okay to have blank rows.

Thanks in advance for your help.