Forum Discussion

Benjwg's avatar
Benjwg
Copper Contributor
Apr 10, 2019

Help with either VLOOKUP or IF AND statements

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.
Formulas and Functions

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 10, 2019
    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.

Resources