Forum Discussion
Benjwg
Apr 10, 2019Copper Contributor
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 sel...
SergeiBaklan
Apr 10, 2019Diamond Contributor
Benjwg , that could be
=LOOKUP(A1, {"Both","M1","M2"}, {"90","80","100"})