Replacing values in one column with values in another column matching names

%3CLINGO-SUB%20id%3D%22lingo-sub-2239981%22%20slang%3D%22en-US%22%3EReplacing%20values%20in%20one%20column%20with%20values%20in%20another%20column%20matching%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2239981%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20Excel%20to%20find%20a%20%22name%20and%20value%22%20and%20change%20the%20value%20from%20another%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2239981%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2241294%22%20slang%3D%22en-US%22%3ERe%3A%20Replacing%20values%20in%20one%20column%20with%20values%20in%20another%20column%20matching%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241294%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1010555%22%20target%3D%22_blank%22%3E%40DLEE_%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ECouldn't%20understand%20exactly%20from%20the%20translation%20what%20your%20plans%20are.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ENevertheless%2C%20I%20am%20sending%20you%20information%20from%20Microsoft%20that%20might%20help%20you.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CH1%20id%3D%22toc-hId-1299665390%22%20id%3D%22toc-hId-1299665388%22%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ffind-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EFind%20or%20replace%20text%20and%20numbers%20on%20a%20worksheet%3C%2FA%3E%3C%2FH1%3E%3CP%3EUse%20the%20Find%20and%20Replace%20features%20in%20Excel%20to%20search%20for%20something%20in%20your%20workbook%2C%20such%20as%20a%20particular%20number%20or%20text%20string.%20You%20can%20either%20locate%20the%20search%20item%20for%20reference%2C%20or%20you%20can%20replace%20it%20with%20something%20else.%20You%20can%20include%20wildcard%20characters%20such%20as%20question%20marks%2C%20tildes%2C%20and%20asterisks%2C%20or%20numbers%20in%20your%20search%20terms.%20You%20can%20search%20by%20rows%20and%20columns%2C%20search%20within%20comments%20or%20values%2C%20and%20search%20within%20worksheets%20or%20entire%20workbooks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Mark%20and%20Vote%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want Excel to find a "name and value" and change the value from another column.

1 Reply

@DLEE_ 

 

Couldn't understand exactly from the translation what your plans are. Nevertheless, I am sending you information from Microsoft that might help you.

Find or replace text and numbers on a worksheet

Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. You can search by rows and columns, search within comments or values, and search within worksheets or entire workbooks.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Mark and Vote if it helps please, as it will be beneficial to more Community members reading here.