Forum Discussion
Setting one cell's value based on anoth
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
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!
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!