Grabbing multiple selections in external data import
 

I've run into a problem when I try to import data from an Access table into
Excel. I can easily import off of one specific variable (i.e. State = NY),
however I can't seem to pull off more than one variable (i.e. I cannot pull
in State = NY or PA).

I would prefer to use the "Get the value from the following cell" bubble,
which could reference a formula that references to cells where NY & PA could
be selected from. So if cell A1 reads NY, and Cell A2 reads PA, I would have
a cell in A3 saying A1&" or "&A2 (NY or PA)

The actual variable I am using is a text field that is a number (so 1234
stored is text)

Is there a way to do this?