G
Guest
I would like to know which single function I should use to assign a number
value to a chosen set of words within a cell and place the value in another
cell ie:
if worksheet1,c4 is equal to "High" then worksheet2,d17 will be 3, or
if worksheet1,c4 is equal to "Medium" then worksheet2,d17 will be 2, or
if worksheet1,c4 is equal to "Low" then worksheet2,d17 will be 1
value to a chosen set of words within a cell and place the value in another
cell ie:
if worksheet1,c4 is equal to "High" then worksheet2,d17 will be 3, or
if worksheet1,c4 is equal to "Medium" then worksheet2,d17 will be 2, or
if worksheet1,c4 is equal to "Low" then worksheet2,d17 will be 1