Lookup multiple values on an array

[slora00]

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!

 

[jasonb75]

I'm getting a little lost on what should be looked up where from your question. Are we looking up the value of column T in C:G, or are we looking up C:G elsewhere?

Also, with reference to the search being done with C:G (whichever way it goes), are we taking the first match (or the only match)? If it is known that there will only ever be one valid match then that would make things easier. If there could be more than one match and the first one needs to be used then it can still be done but would be a little more complex.

Finally, do the cells all contain numbers, all contain text, or a mixture of both? Different data types often need different formulas. With the question that you're asking, the formula that you need will be very specific to your exact requirements so we will need as much detail as possible in order to get it right.