Automating values inside a column

Hi! I have been learning to use the Excel software . I am trying to create a column named "Colour Code" which represents a number based on another column called "Weight". I need to automate this proc...

excel

Formulas and Functions

office 365

Riny_van_Eekelen
May 13, 2020
Mrinal1996 I believe that you first need to create a table with weight codes and their matching color code. Something like in the attached picture, where the green areas contains the weight/color table. Column D has the weights and column E looks up the corresponding color code from the weight table.

Abiola1

MVP

May 12, 2020

Hello,

Your IF formula will be as such
=IF(C2=3,3,0)

Mrinal1996
Copper Contributor
May 13, 2020
Abiola1 So when I try doing that I am not geting the values on my excel sheet.
- Abiola1
  MVP
  May 13, 2020
  Its better to attach the file than pictures
  - Mrinal1996
    Copper Contributor
    May 13, 2020
    Abiola1 Hi! I am sorry for that. I will attach the file along with this message.
    
    Producer_Network_Weighted_w_Coordinates_Subset.xlsx8.7 MB

Forum Discussion

Automating values inside a column

Resources