vlookup question [SOLVED]

[rahulsharma012]

i am not getting correct result in c2 column and down using vlookup approach instead of if condition.below is the link for file.


http://www.fileconvoy.com/dfl.php?id=gab0329ab80a475c1999307434d4c78545a2825501


Regards,

Rahul

 

[webmax]

hi,


first two have to sort the marks in ascending order for example like this


marks grade

20 f

50 c

70 b

90 a


and try this formula =VLOOKUP(B2,$E$1:$F$5,2,1)

 

[rahulsharma012]

thanks a lot webmax