I have a list of 168 people that I am using in conjunction with a Xcelsius 2008 USA map. I'm using the map to mouse-over to enter a state code into the sheet in H1. I want to lookup all people who live in Texas, returning their names (unique) and City (could be duplicates) which I will display in text boxes. My goal is a mouse-over map that shows a list of staff names and cities in the state.
No headers
Column A: two-letter US State codes (sorted A-Z)
Column B: Last, First (names)
Column C: City Name
Column H2:H23: copies of H1 (my longest list of people is 21 names in a state)
Column I2:I23: cities that correspond to the names
I have done searching elsewhere, but, I'm not coming up with anything that fits or that I've found out how to mod for my needs. TIA.
Since I am using Xcelsius, ROW is not a supported function.
No headers
Column A: two-letter US State codes (sorted A-Z)
Column B: Last, First (names)
Column C: City Name
Column H2:H23: copies of H1 (my longest list of people is 21 names in a state)
Column I2:I23: cities that correspond to the names
I have done searching elsewhere, but, I'm not coming up with anything that fits or that I've found out how to mod for my needs. TIA.
Since I am using Xcelsius, ROW is not a supported function.