Forum Discussion
Solved
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 process since the number of columns are large.For eg: if the Weight shows 3, I need to have the numerical "3" in my Color Code list.
How do I go about this? Hoping to hear from you soon.
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.
10 Replies
- Hello,
Your IF formula will be as such
=IF(C2=3,3,0)- Its better to attach the file than pictures
