Help with either VLOOKUP or IF AND statements

[Benjwg]

Hello,

New here, hoping for help with quite a simple formula that I can't figure out..

Example..
I have a drop down list with titles M1, M2 and Both. I have the formula set so that if M2 is selected in cell A1, the cell in B1 gives value "100"..

I need it set so that if A1 has "M2", "M1" or "Both", B1 will then give values "100" "80" or "90" ...

Can anyone help please?

Thanks.

[#2]

@Benjwg , that could be

=LOOKUP(A1, {"Both","M1","M2"}, {"90","80","100"})

[#3]

To make this as flexible as needed, you could enter M1, M2 and Both into a small table with the approrpiate numbers next to them. Then you can use VLOOKUP to lookup the information from that table.