Using VLOOKUP

Question

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?

Answer 1

Vlookup takes the lookup value first, so change the first C8 to A8.

I hope this helps you.