Not sure what the best function should be.
Hi,
One way. Change the values to suit
=LOOKUP(B2,{"A","B","C","D"},{1.5,2.5,3.7,4.9})
In practice you could use cell references for the values
=LOOKUP(B3,{"A","B","C","D"},$K$1:$K$4)
Mike
Mike
"Jose'" wrote:
I want a function that will put a cost amount in the Cost column based on
Plan type; for example if Plan=C then cost will be 6.17 if Plan=A then cost
will be 7.10.
I am not sure if this should be an IF(OR) statement or some other function
and how to write that function.
example
Item Plan Cost
xxx C 6.17
xxx A
xxx C
xxx A
xxx C
Thanks in advance
|