nepotist
05-26-2011, 10:37 AM
Hello my excel sheet is in the following format
Type Reason Code
A_0L_0R Standard
A_WL_0R A_0L_0R - Reduced by 5% 1
A_WL_WR A_WL_0R - Increased by 5% 1,2
I would like to a lookup to update Code Column. If you look at row two (A_WL_0R) has a code of 1 with a manipulation on row one(A_0L_0R). the code in row three is 1,2 as it is based on manipulation on row two which as a code of one and then 2 is added later. I would like to update column code using a formula. Any Ideas?
Type Reason Code
A_0L_0R Standard
A_WL_0R A_0L_0R - Reduced by 5% 1
A_WL_WR A_WL_0R - Increased by 5% 1,2
I would like to a lookup to update Code Column. If you look at row two (A_WL_0R) has a code of 1 with a manipulation on row one(A_0L_0R). the code in row three is 1,2 as it is based on manipulation on row two which as a code of one and then 2 is added later. I would like to update column code using a formula. Any Ideas?