Forum Discussion
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...
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.