lookup function

[bohon79]

Hello,

trying to cell a cell to change a number based on text in another cell. here is the lookup function I am using:

=LOOKUP(D2,{"DMSM","JSCM","JSAM","LOM","MSM","ARCOM","AAM"},{"120","60","60","120","90","60","60"})

so if I put dmsm in d2 it shows 120 or if I put jsam in d2 it should show 60. but when I test it, it puts 120 instead of 60 and some just put n/a

any help.

thanks erick

 

[JoeMo]

LOOKUP requires the input vector ({"DMSM","JSCM","JSAM","LOM","MSM","ARCOM","AAM"}) to be in ascending order. So, your formula stumbles.

 

[bohon79]

thank you. thank worked.

 

[Aladin Akyurek]

Better...

=INDEX({120,60,60,120,90,60,60},MATCH(D2,{"DMSM","JSCM","JSAM","LOM","MSM","ARCOM","AAM"},0))​