Results from combo box selection (2003 SP3)

[steveh]

Good afternoon

I am sure that I have dones this / have asked for help about this before but I cannot find it here or 'in the other place'

I have a combo that selects information from (Country) B39:B825 in (DayTime) C39:C825 is a day and a time, in (Condition) D39:D825 weather conditions and (Temp) E39:E825 the current temperature, the names in brackets are what I have called the ranges.

When I select a Country / Airport from the Combo I would like the corrosponding information displayed in 3 different cells, for example

Country = Albania-Tirana
Day - Time = Mon, 16:06
Conditions = Scattered Cloud, Warm
Temperature = 23^oC

I have Googled but I am either asking the wrong question or asking for something that Excel doesn't naturally do (I would prefer not to use code)

Ta

[StuartR]

If you create a range that includes B39:E825 and call it WeatherData, and assuming that the cell where you have displayed the currently selected country/airport is D16, you could put the following formula in E16.

=Vlookup($D$16, Weatherdata, 2, False)

Replace the 2 with 3 or 4 to get conditions or temperature.

[steveh]

If you create a range that includes B39:E825 and call it WeatherData, and assuming that the cell where you have displayed the currently selected country/airport is D16, you could put the following formula in E16.

=Vlookup($D$16, Weatherdata, 2, False)

Replace the 2 with 3 or 4 to get conditions or temperature.

Thanks Stuart

I have now put that in my tips woorkbook for future use