Good night,
I have a problem with excel that I can not solve.
I have a database (Columns K, L and M) and with it I need to fill my column C, as follow image:
Sem_título.jpg
I need a sort of VLOOKUP that looks for the range of column A and B in the range of column K and L to give me the value of M.
In other words the range, for example from 0 to 31,254, is within which range of column K and L? In gives me type A.
I can do a lot of "ifs" but the database is much larger than that of the image. I need a way to do this with some function.
Does anyone know how to help me?
Thank you
Bookmarks