three side v look up and match formula

[mitesh jain]

Hello every one ,

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

 

[oldbrewer]

your first and third tables, and second and fourth, are identical. What do you want ?

 

[hvdlinde]

could you enhance your example to clarify your need?