Lookup that returns data for multiple states

[adhamija]

I have a set of data in one sheet that has the following:state code (e.g. CA), ID#, and a bunch of medical data. There are about 1200 IDs. Let's call that sheet StateData. I have 3 other sheets: red states, blue states, and purple states. In each of those sheets, I have the state code that I want. What I want to do is do a lookup that returns the corresponding data from StateData for each state in the "red states", "blue states" and "purple states."

An example is listed below:

StateData

State ID# systolic.... etc......etc.
AK 19102A 135
AK 19102B 125
AL 23102A 154
AL " "
CA " "
CA " "

Red States
AK
AL
WY

*I want a lookup that will return all of the information for each ID that has state code AK, then all of those for AL, then all of those for WY, etc.


Thank you so much!
-Anish

[adhamija]

I should add that I want to do the same for blue states and purple states as well.