Forum Discussion

cmckernan93's avatar
cmckernan93
Copper Contributor
Nov 12, 2021
Solved

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 ...
admin
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 12, 2021

    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!

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Nov 12, 2021

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!

 

Resources