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
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
Last edited: