I am using Excel's VLOOKUP() first time and I am having hard time with it. Here is the screenshot:
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?
Thanks for the help!
Best Answer
A vlookup looks for a value in the leftmost column of a table and then returns a value from the row that the searched for value is found (how far along that row is determined by you).
In your example situation, you need to add in the 4th part below (NearOrExact)
The vlookup formula consists of 4 parts:
Structure of the vlookup formula: =vlookup ( SearchFor , WhereToSearch , WhichColumn , NearOrExact )
From <http://www.excelvlookuphelp.com/how-to-use-vlookup/>