VLookup Question

[dernspiker]

I know this is pretty simple but I cannot remember how to do this:

I have 2 columns "Region (Column A)" and "Country (Column B)"

Only Country has data in it, such as country abbreviations.

We have 4 distinct Regions in our company and every abbreviation in Column B fits into one of them.

I need to tell excell to look in Column B, find the abbreviation such as US and put "Americas" in the cell for Column A, then continue until all are assigned a region.

Any need for clarification just ask,

Thanks!

 

[prajul89]

So it requires just Vlookup right??
Do You have a table of All Countries and Regions??

 

[dernspiker]

Not yet it is in an excel spreadsheet with many many columns. But, I can create one pretty quickly if necessary.

Dana

 

[prajul89]

=VLOOKUP(B2,I:J,2,0)

This will go in your A column
Where B2 is your Country and I:J would be your Table where I column would contain country code and J would contain Region.

 

[T. Valko]

I know this is pretty simple but I cannot remember how to do this:

I have 2 columns "Region (Column A)" and "Country (Column B)"

Only Country has data in it, such as country abbreviations.

We have 4 distinct Regions in our company and every abbreviation in Column B fits into one of them.

I need to tell excell to look in Column B, find the abbreviation such as US and put "Americas" in the cell for Column A, then continue until all are assigned a region.

Any need for clarification just ask,

Thanks!

See this...

http://contextures.com/xlFunctions02.html