Forum Discussion
Automating values inside a column
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.
wumolad Hey thabkyou for working on this.SO basically what I wanted to do was the latter but in a refined form, as in, all the weights with label "2" should have colour code as 1 , weight "3" as colour code 2, etc.
This i=one is fine as well but if I were to label(colour code) ,say, weight , "128" as "7", how do i do that?
Hoping to hear from you soon.
Regards,
Mrinal Subash
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.
Mrinal1996 The "green table" is no more than two columns with information. One with the weight in the first column and the corresponding color in the second. You can put it anywhere you like. In the same sheet or another.
The VLOOKUP function take has four parameters.
1. what to look for (the weight)
2. where to look (the "green table")
3. which column to take data from (the second one in the "green table")
4. type of match (TRUE or 1 = approximate match, FALSE or 0 = exact match)
You can read more on VLOOKUP in the MS support pages, here:
https://support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1
- Riny_van_Eekelen Thankyou for this .I think this is the right way to go about it. How do I create that green table ? Just by inserting table on the side? Also may I know what thew parameters denote in the VLOOKUP function that you have in Microsoft Excel?
Regards,
Mrinal Subash