In one spreadsheet I have two different tabs. I would like Tab A to pull data
from Tab B (contained in the same file). On Tab A, I have added a dropdown
menu that a user selects a state. On Tab B I have a many different cells I
would like to pull data from for each state. For example, if I choose
€œIndiana€� in the drop down menu, I would like the report in Tab A to prefill
with information (pulled from Tab B) pertinent to Indiana. If I choose
Florida, then Florida and so on. Tab B (the data) contains information from
years 2004 €“ 2008.

How do I go about having cells in Tab A, pull the correct data from Tab B by
specific state? What function do I use and how do I use it?

Thank you.


jba