mitesh jain
New Member
- Joined
- Jan 9, 2017
- Messages
- 1
Hello every one ,
hi i have a file and want three side vlook up and match formula in two file please help me out
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
<colgroup><col span="4"></colgroup><tbody>
</tbody>
For example size .90 to .99 color d and clarity if =-48 fro m first file
second file -5 = -48+-5 =-53
hi i have a file and want three side vlook up and match formula in two file please help me out
0.90-0.95 | |||||||
IF | VVS1 | VVS2 | VS1 | VS2 | SI1 | SI2 | |
D | -48 | -48 | -48 | -43 | -43 | -38 | -38 |
E | -48 | -48 | -48 | -43 | -43 | -38 | -38 |
F | -48 | -48 | -46 | -43 | -43 | -38 | -38 |
G | -43 | -41 | -41 | -38 | -38 | -37 | -40 |
H | -43 | -41 | -41 | -38 | -38 | -37 | -40 |
I | -44 | -42 | -42 | -42 | -42 | -42 | -42 |
J | -44 | -42 | -42 | -42 | -42 | -42 | -42 |
K | -42 | -42 | -42 | -42 | -42 | -42 | -42 |
L | -45 | -42 | -42 | -42 | -42 | -45 | -45 |
M | -45 | -42 | -42 | -42 | -42 | -45 | -45 |
0.96-0.99 | |||||||
IF | VVS1 | VVS2 | VS1 | VS2 | SI1 | SI2 | |
D | -43 | -43 | -43 | -38 | -38 | -35 | -35 |
E | -46 | -43 | -43 | -38 | -38 | -35 | -35 |
F | -48 | -43 | -43 | -38 | -38 | -35 | -35 |
G | -41 | -38 | -38 | -33 | -33 | -34 | -37 |
H | -41 | -38 | -38 | -33 | -33 | -34 | -37 |
I | -42 | -39 | -39 | -39 | -39 | -37 | -37 |
J | -42 | -39 | -39 | -39 | -39 | -37 | -37 |
K | -40 | -40 | -40 | -40 | -40 | -40 | -40 |
L | -42 | -42 | -42 | -42 | -42 | -42 | -42 |
M | -42 | -42 | -42 | -42 | -42 | -42 | -42 |
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
0.90-0.95 | |||||||
IF | VVS1 | VVS2 | VS1 | VS2 | SI1 | SI2 | |
D | -48 | -48 | -48 | -43 | -43 | -38 | -38 |
E | -48 | -48 | -48 | -43 | -43 | -38 | -38 |
F | -48 | -48 | -46 | -43 | -43 | -38 | -38 |
G | -43 | -41 | -41 | -38 | -38 | -37 | -40 |
H | -43 | -41 | -41 | -38 | -38 | -37 | -40 |
I | -44 | -42 | -42 | -42 | -42 | -42 | -42 |
J | -44 | -42 | -42 | -42 | -42 | -42 | -42 |
K | -42 | -42 | -42 | -42 | -42 | -42 | -42 |
L | -45 | -42 | -42 | -42 | -42 | -45 | -45 |
M | -45 | -42 | -42 | -42 | -42 | -45 | -45 |
0.96-0.99 | |||||||
IF | VVS1 | VVS2 | VS1 | VS2 | SI1 | SI2 | |
D | -43 | -43 | -43 | -38 | -38 | -35 | -35 |
E | -46 | -43 | -43 | -38 | -38 | -35 | -35 |
F | -48 | -43 | -43 | -38 | -38 | -35 | -35 |
G | -41 | -38 | -38 | -33 | -33 | -34 | -37 |
H | -41 | -38 | -38 | -33 | -33 | -34 | -37 |
I | -42 | -39 | -39 | -39 | -39 | -37 | -37 |
J | -42 | -39 | -39 | -39 | -39 | -37 | -37 |
K | -40 | -40 | -40 | -40 | -40 | -40 | -40 |
L | -42 | -42 | -42 | -42 | -42 | -42 | -42 |
M | -42 | -42 | -42 | -42 | -42 | -42 |
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
Size | color | clarity | Faint |
0.90-0.99 | DEF | IF-VVS2 | -5 |
0.90-0.99 | DEF | VS1-VS2 | -5 |
0.90-0.99 | DEF | SI1-SI2 | -3 |
0.90-0.99 | G-H | IF-VVS2 | -3 |
0.90-0.99 | G-H | VS1-VS2 | -3 |
0.90-0.99 | G-H | SI1-SI2 | -2 |
0.90-0.99 | I-J | IF-VVS2 | -2 |
0.90-0.99 | I-J | VS1-VS2 | -2 |
0.90-0.99 | I-J | SI1-SI2 | 0 |
0.90-0.99 | K-M | IF-VVS2 | 0 |
0.90-0.99 | K-M | VS1-VS2 | 0 |
0.90-0.99 | K-M | SI1-SI2 | 0 |
Size | color | clarity | Faint |
1.00-1.29 | DEF | IF-VVS2 | -5 |
1.00-1.29 | DEF | VS1-VS2 | -5 |
1.00-1.29 | DEF | SI1-SI2 | -2 |
1.00-1.29 | G-H | IF-VVS2 | -3 |
1.00-1.29 | G-H | VS1-VS2 | -3 |
1.00-1.29 | G-H | SI1-SI2 | -2 |
1.00-1.29 | I-J | IF-VVS2 | -1 |
1.00-1.29 | I-J | VS1-VS2 | -1 |
1.00-1.29 | I-J | SI1-SI2 | 0 |
<colgroup><col span="4"></colgroup><tbody>
</tbody>
For example size .90 to .99 color d and clarity if =-48 fro m first file
second file -5 = -48+-5 =-53