| Author |
 Topic  |
|
|
jasonmorales1618
1 Posts |
 Posted - 06/11/2015 : 1:57:30 PM
|
Origin Ver. 2015 SR0 and Service Release (Select Help-->About Origin):
Operating System: Windows 7 64 bit
Problem:
Having trouble using "Lookup" function. I'm trying to use it like 'vlookup' in MS Excel.
Environment:
Single workbook: "Book1"
Multiple worksheets: "Sheet 1", "Lists"
Columns:
"Lists"
Col(A) Col(B)
format: [text] [text]
1 red
2 green
3 blue
4 brown
"Sheet 1"
Col(C) Col(D)
format: [text] [text]
1
1
4
2
3
1
...
Under 'F(x)=' in Col(D) I have tried:
'Lookup(Col(C),Lists!Col(A),Lists!Col(B))'
I'm getting errors that 'Col(A) is unknown'
I have playing around with different derivations of the above 'Lookup' example I gave, the best I could get would be to have every row in Col D populated with 'red'. It looks like it is taking the first entry in Col(C) only. |
|
|
snowli
USA
1386 Posts |
Posted - 06/11/2015 : 2:39:44 PM
|
Hello,
Origin doesn't support Lists!Col(A) syntax to call columns on different sheet or book. You have to define range variable in Before formula script for such columns first.
Also when using Lookup(), don't forget to add $ after ().
See how I made it work:
BTW, in SCV dialog, if you double click lookup in the formula box, you can see the syntax and example.
Thanks, Snow |
 |
|
| |
Topic |
|
|
|
Lookup help