Chromatography Forum

Hi ,

Anybody know of a suitable custom field or ENUM (Intersample) custom field equivalent to what Excel function VLOOKUP carries out

ie

If SUM = x then VLOOKUP (VALUE)

where values are constant and are fixed depending on value of X

Thanks

Hi

No takers on this subject

Would a Boolean variable or a translation work ?

ie for t-tables for example
where degrees of freedom 95%
df
10 2.22814
11 2.20099
12 2.17881
13 2.16037
14 2.14479
15 2.13145
16 2.11991
17 2.10982
18 2.10092
19 2.09302
20 2.08596

=VLOOKUP(C23,t_table_probs!A4:B33,2) - Excel equivalent

I don't have empower in front of me at the moment

Thanks