Look up then insert value in next column
 

How can I automate this? Please note I'm not too good with macros, if that's
what's required, but I like to try.

I have a list of countries in column 1 with corresponding values in column
2. I have a second spreadsheet with the same countries in column 1 and a new
set of values in column 2.

how can I have the countries in col 1 of ss 2 looked up and matched with the
countries in col 1 of ss 1 and insert the value from col 2 of ss 2 into col 3
of ss 1.

any countries where the spelling is slightly different would be marked in
red or otherwise indicated that a match was not possible (probably the
indication would be on ss 2 since that is where the failed matched country
originated from).

I can't find a function or set of functions which does this.

hopefully, this is possible and can be automated. appreciate your help.

Try this in C1 of worksheet 1 and fill down:

=VLOOKUP(A1,ss2!A:B,2,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I automate this? Please note I'm not too good
with macros, if that's
what's required, but I like to try.

I have a list of countries in column 1 with
corresponding values in column
2. I have a second spreadsheet with the same countries
in column 1 and a new
set of values in column 2.

how can I have the countries in col 1 of ss 2 looked up
and matched with the
countries in col 1 of ss 1 and insert the value from col
2 of ss 2 into col 3
of ss 1.

any countries where the spelling is slightly different
would be marked in
red or otherwise indicated that a match was not possible
(probably the
indication would be on ss 2 since that is where the
failed matched country
originated from).

I can't find a function or set of functions which does
this.

hopefully, this is possible and can be automated.
appreciate your help.
.

I think I followed your instruction, but I get a #N/A, which I guess is a
non-match. I did a 4 row sample worksheet which I can email to you if this
would help. Otherwise, any idea why this is not working?

"Jason Morin" wrote:

Try this in C1 of worksheet 1 and fill down:

=VLOOKUP(A1,ss2!A:B,2,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
How can I automate this? Please note I'm not too good
with macros, if that's
what's required, but I like to try.

I have a list of countries in column 1 with
corresponding values in column
2. I have a second spreadsheet with the same countries
in column 1 and a new
set of values in column 2.

how can I have the countries in col 1 of ss 2 looked up
and matched with the
countries in col 1 of ss 1 and insert the value from col
2 of ss 2 into col 3
of ss 1.

any countries where the spelling is slightly different
would be marked in
red or otherwise indicated that a match was not possible
(probably the
indication would be on ss 2 since that is where the
failed matched country
originated from).

I can't find a function or set of functions which does
this.

hopefully, this is possible and can be automated.
appreciate your help.
.