Excel doubt on vlookup

Sreevidhya V (176 Points)

06 January 2018  

Dear All,*

I am attaching herewith a file where i have a problem in vlookup formula. For a particular desc 18*50 - lookup picks up the amount of 180*250. pls refer the attached file and let me know where i am going wrong and how to correct the same?

Value of 18*50 is Rs.25   value of 18*250 is 60.  against 18*50 vlookup functions returns Rs.60.... Pls help. 


Sreevidhya V