| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
match function? I don't know what I can apply
Can anyone help?
I have a column (second column) with countries that are in my data; but I would like to change the names for certain countries to different names (first column- data that I would like to have for specific countries). I do not know what formula should I choose for column 1 or hom to arrange (match or vlookup so it would simply work) Column1 Column2(data) Benelux Belgium Benelux Netherlands Nordic Denmark Nordic Finland Nordic Norway Nordic Sweden Russia Russia Exp UK United Kingdom France France Iberia Iberia Italy Italy |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
match function? I don't know what I can apply
Hi,
I am not sure if I am reading the question correctly, but, why don't you use the find/replace to change the names of the countries in the second column? Ivan "new_121" wrote: Can anyone help? I have a column (second column) with countries that are in my data; but I would like to change the names for certain countries to different names (first column- data that I would like to have for specific countries). I do not know what formula should I choose for column 1 or hom to arrange (match or vlookup so it would simply work) Column1 Column2(data) Benelux Belgium Benelux Netherlands Nordic Denmark Nordic Finland Nordic Norway Nordic Sweden Russia Russia Exp UK United Kingdom France France Iberia Iberia Italy Italy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I apply my function to the entire column? | Excel Discussion (Misc queries) | |||
| How do I apply a function to an entire column? | New Users to Excel | |||
| want to apply function to numerous cells | Excel Discussion (Misc queries) | |||
| i want to use the =if function to apply a colour to other cells | Excel Worksheet Functions | |||
Linear Mode
