M
monagan
I have a table of wind speeds for 322 cities.
I have them visually grouped by city with high, average, low
This is what my project looks like so far:
State
City
Wind Speed
These are drop down boxes.
Wind speed is high, average, low
I have three cells layed out
Hi:
Avg:
Lo:
Depending on the state on city, I need the specific three cells in th
table to "copy" to the thre I mention directly above.
any Ideas of how I can get excel to "find" the cells I need dependin
the city and state, and then use those values in the three (hi,avg,lo
cells
I have them visually grouped by city with high, average, low
This is what my project looks like so far:
State
City
Wind Speed
These are drop down boxes.
Wind speed is high, average, low
I have three cells layed out
Hi:
Avg:
Lo:
Depending on the state on city, I need the specific three cells in th
table to "copy" to the thre I mention directly above.
any Ideas of how I can get excel to "find" the cells I need dependin
the city and state, and then use those values in the three (hi,avg,lo
cells