Hi all,

I am wondering how I can reference a value in a specific column based on a reference column. The concept is just like VLOOKUP in Excel. I have a data table with a name and there is a unique threshold value for that specific name.

```
Variability Chart(
Y( :Signal ),
X( :Expected Outcome, :Sample Mix, :Consumable ),
Max Iter( 100 ),
Conv Limit( 0.00000001 ),
Number Integration Abscissas( 128 ),
Number Function Evals( 65536 ),
Analysis Type( Name( "Choose best analysis (EMS REML Bayesian)" ) ),
Process Variation( 0 ),
Show Range Bars( 0 ),
Show Cell Means( 0 ),
Std Dev Chart( 0 ),
Points Jittered( 1 ),
Show Box Plot Whisker Bars( 0 ),
Mean Diamonds( 0 ),
By( :Description ),
SendToReport(
Dispatch(
{"Variability Chart for Signal"},
"2",
ScaleBox,
{Scale( "Log" ), Min( 0.01 ), Max( 1250 ), Inc( 1 ), Minor Ticks( 8 ), Add Ref Line( 0, Dotted, "Medium Light Gray" ),
Add Ref Line(
```*****[5/(I want this to be the value based on the By reference in the variability chart]*****, Dotted, "Black" ), Rotated Labels( "Horizontal" )}
)
)
);

In my head it would be get the current value of :Description in the By grouping and then find the corresponding value of the threshold in the "Threshold (nA)" column. But I am unsure how to do this.

A simpler example is:

Example Data table:

A B C

1 2 3

1 4 3

2 6 5

2 7 5

3 4 4

4 9 4

My variability graph will be plotting B as the y axis but I want a horizontal line based on My By which in this case would be A so 1, 2, 3. So my three variability graphs will have 3, 5, and 4 as respective horizonal lines based on the value of A. As of now I am unsure how to get this value and plug it into the code above to get a dynamic horizonal line by description as my By grouping. Any help would be greatly appreciated. Thanks!