Hello guys, I've got quite a challenge for you here... I'm battling with this case.
I'm trying to assign a number to the cells on column AR, based on another 6 columns. First, Excel has to look on the value of column T, and if its 12, 13 or 14, return "12000", otherwise, it would have to search the number on another table based on the values from column C to G. What I'm trying to do is "take the value on column C, search on the specified table, and if you don't find it, repeat the process on column D" and so on so on.
I tried to make it combining IF and VLOOKUP, but as my lookup value would be of 5 columns (columns C to G), I haven't found a way of making this possible.
If you know a way to do it via VBA or normal formulas, please let me know!
I'm trying to assign a number to the cells on column AR, based on another 6 columns. First, Excel has to look on the value of column T, and if its 12, 13 or 14, return "12000", otherwise, it would have to search the number on another table based on the values from column C to G. What I'm trying to do is "take the value on column C, search on the specified table, and if you don't find it, repeat the process on column D" and so on so on.
I tried to make it combining IF and VLOOKUP, but as my lookup value would be of 5 columns (columns C to G), I haven't found a way of making this possible.
If you know a way to do it via VBA or normal formulas, please let me know!