View Single Post
  #8 (permalink)  
Old November 26th, 2013, 10:28 PM
s.lucky s.lucky is offline
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Nov 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Change Value to Number and get the sum

Hi,
This is regarding excel data formating,
I want to take the values from 10 different fields which will have the values as per the drop down and then sum its correspending rating

I found very good solution which has been very useful, however, the field value is not giving me the exact result as per the values in Lookup vector and result vector.
For Eg. If im giving ::
=LOOKUP(C2,{"","AE","OE","NE","BE"},{0,5,3,1,0})
and if i pick NE from drop down, it takes the value 5

Can you please help.

Regards
Reply With Quote