forum_vlookup of different formulas
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTU
1
WHAT I HAVE
2
PriorityNameDifferent Formulas
3
1a70
4
2b1125
5
3c-20
6
4d0.56
7
8
Time01234567
9
Data 12524.52423.52322.52221.5
10
Data 24543413937353331
11
12
13
WHAT I WANT
14
If I set priorities like...
15
16
Priority
17
4
18
3
19
2
20
1
21
22
... then I want to get
23
24
Name/Time012345
25
d0.560.570.590.600.620.64
26
c-20-18.5-17-15.5-14-12.5
27
b11251053.5984916.5851787.5
28
a7067.56562.56057.5
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Task
Yogi
3
A1+1