SOLVED

Setting one cell's value based on anoth

%3CLINGO-SUB%20id%3D%22lingo-sub-2958492%22%20slang%3D%22en-US%22%3ESetting%20one%20cell's%20value%20based%20on%20anoth%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2958492%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%20I%20have%20attatced%20a%20test%20excel%20file%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20want%20is%20to%20run%20a%20possible%20IF%20function%20that%20will%20genrate%20colums%20L%2BM%20off%20column%20E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20while%20i%20have%20multiple%20product%20codes%20(%2B50)%20%2C%20i%20want%20the%20brand%20and%20category%20to%20generate%20automatically%20when%20i%20input%20that%20code%20into%20column%20E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20Kind%20REgards%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2958492%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2958550%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20one%20cell's%20value%20based%20on%20anoth%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2958550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960851%22%20target%3D%22_blank%22%3E%40cmckernan93%3C%2FA%3E%26nbsp%3BCreate%20a%20reference%20table%20(a.k.a.%20lookup%20table)%20where%20you%20enter%20the%20code%2C%20the%20brand%20and%20the%20category%2C%20each%20in%20its%20own%20column%2C%20for%20all%20products.%20Then%2C%20in%20columns%20L%20and%20M%2C%20use%20VLOOKUP%20(or%20XLOOKUP%20is%20your%20Excel%20version%20supports%20it)%20to%20lookup%20the%20code%20from%20E%20in%20the%20first%20column%20of%20the%20reference%20table%20and%20have%20it%20return%20the%20value%20from%20either%20the%202nd%20or%203rd%20column%20if%20an%20exact%20match%20if%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

hello, I have attatced a test excel file

 

What want is to run a possible IF function that will genrate colums L+M off column E,

 

so while i have multiple product codes (+50) , i want the brand and category to generate automatically when i input that code into column E.

 

Thanks, Kind REgards 

1 Reply
best response confirmed by cmckernan93 (Occasional Contributor)
Solution

@cmckernan93 Create a reference table (a.k.a. lookup table) where you enter the code, the brand and the category, each in its own column, for all products. Then, in columns L and M, use VLOOKUP (or XLOOKUP is your Excel version supports it) to lookup the code from E in the first column of the reference table and have it return the value from either the 2nd or 3rd column if an exact match if found.

 

See attached!