Get data from multiple cells to another set of cells

  • Thread starter Thread starter monagan
  • Start date Start date
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
 
How does the layout look in the wind speed table

City High Average Low

e.g.

Viginia Beach 25 Mph 8.8 Mph 1.2 Mph

if it looks something like that and the table is called MyTable you can use

With the City in cell G1 (replace with the cell address for your city)

=VLOOKUP(G1,MyTable,2,0)

will return the max speed

=VLOOKUP(G1,MyTable,3,0)

average

and

=VLOOKUP(G1,MyTable,4,0)

min


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
I would make a VLOOKUP table, named TEMPTABLE with my left column being a
Concatenation of my StateCity........such as "MichiganDetroit", with the
High, Average, and Low temperatures in the three cells to the right of each
StateCity..........

Then, assuming your StateCell was F53 and your CityCell was F54,

put this formula in the cell where you want the High temperature.........
=VLOOKUP(CONCATENATE(F53,F54),TEMPTABLE,2,FALSE)

put this formula in the cell where you want the Average temperature.....
=VLOOKUP(CONCATENATE(F53,F54),TEMPTABLE,3,FALSE)

put this formula in the cell where you want the Low temperature..........
=VLOOKUP(CONCATENATE(F53,F54),TEMPTABLE,4,FALSE)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top