cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Need a basic help

ptc-5008809
1-Visitor

Need a basic help

the details are already mentioned in it...please could sme1 help in sorting this thing out...thanks

2 REPLIES 2
Werner_E
25-Diamond I
(To:ptc-5008809)

"lookup" returns a vector, not a scalar value. This is necessary, as there could be more than one match and its a vector even if only one match was found. So if you are sure there is only one match or you will be happy with the first one in every case, you could write "B <-- lookup(.......)[0". That way B will be a scalar and can be compared to another.

I think you need to explain a little more clearly and upload the Excel worksheet containing the data.

Mike

Announcements

Top Tags