Refer the below link on VLOOKUP() ...

http://www.contextures.com/xlFunctions02.html

If this post helps click Yes
---------------
Jacob Skaria


"kat21" wrote:

I have a spreadsheet with different information for several countries.

I'd like to create a dropdown of all the countries, so when a country is
selected only that inforamtion appears.

I do not know if this is possible, or how to go about doing it, but anything
information would be extremly helpful.

Thanks

I'm using Excel Vista