I'm experiencing trouble with Excel's VLOOKUP() because this is my first time using it. The image is seen below:
I wrote a formula to cell B8; =VLOOKUP(C8, $A$2:$C$5, IF(C8 = "W", 2,3))
I was expecting as a result 1, but I am getting the wrong result 0.25. Am I doing something wrong?