Array formula needed? Not sure how to query a dataset

Hi everyone,

I have a question on building a formula.

Please have a look at the attached sample.

Basically, TABLE2 and TABLE3 need to query TABLE1 and return the results as popluated. I couldn't figure out whether this would be an array formula or a vlookup.