VLOOKUP range of numbers

[lm4]

Hello,

I am trying to install a Vlookup for this data

TOP >2000
PARTICIPAIS >1000<2000
POTENCAIS >500<1000
PARTICIPATIVAS >200<500

meaning if the sale is more than 2000 then it is top , if it is between 1000-2000 it is participais , etc.

I tried using the VLOOKUP with exactly the data i entered above but it did not work.

HELP PLEASE!

Thank you very much

 

[MrKowz]

Welcome to the forums!

Try:

=LOOKUP(A1,{0,200,500,1000,2000},{"Non Ranked","PARTICIPATIVAS ","POTENCAIS","PARTICIPAIS","TOP"})

 

[lm4]

Thank you that worked perfectly !

 

[EmilyM]

Is there a way to do this using values in cells rather than just typing the values into the formula? For example, if my value falls between A1 and B1 then it returns C1?

 

[rguy84]

Is there a way to do this using values in cells rather than just typing the values into the formula? For example, if my value falls between A1 and B1 then it returns C1?

Conditional formatting?

 

[MrKowz]

Is there a way to do this using values in cells rather than just typing the values into the formula? For example, if my value falls between A1 and B1 then it returns C1?

Assuming your list of values is in B1:B10, and the returned values are in C1:C10, try:

=VLOOKUP(A1,B1:C10,2)

 

[EmilyM]

Thank you!

 

[lm4]

Hello,

I am now trying to use Vlookup but for some reason it always gives me the same answer "CLASSE E" no matter the value i am changing in the cell.

this is the lookup table

J K

44 26254 CLASSE A
45 10983.5 CLASSE B
46 3841.5 CLASSE C
47 1939 CLASSE D
48 1106 CLASSE E

this is the value i put in(M34) : 10000 and it gives me CLASSE E which is wrong !

and this is the function i used :

=VLOOKUP(M34,J44:J48:K44:K48,2,TRUE)

Thank you very much

 

[MrKowz]

Hello,

I am now trying to use Vlookup but for some reason it always gives me the same answer "CLASSE E" no matter the value i am changing in the cell.

this is the lookup table

J K

44 26254 CLASSE A
45 10983.5 CLASSE B
46 3841.5 CLASSE C
47 1939 CLASSE D
48 1106 CLASSE E

this is the value i put in(M34) : 10000 and it gives me CLASSE E which is wrong !

and this is the function i used :

=VLOOKUP(M34,J44:J48:K44:K48,2,TRUE)

Thank you very much

The table you are using as the lookup must be in ascending order.