Hi. I don't know if i am doing something wrong. The function is returning all
0. I also try hitting ctl+shift+enter when i enter the function

"Biff" wrote:

Try this:

Sheet2!A$2:A$19 = STYLE
Sheet2!B$2:B$19 = CUT
Sheet2!C$2:C$19 = COLOR
Sheet2!E$2:E$19 = YIELD

=SUMPRODUCT(--(Sheet2!A$2:A$19=B2),--(Sheet2!B$2:B$19=A2),--(Sheet2!C$2:C$19=C2),Sheet2!E$2:E$19)

Biff

"DP7" wrote in message
...
PLEASE DISREGURAD LAST POST. FORMATING ERROR.

Sheet 1
CUT STYLE COLOR Yield
247703 1184I72 ST-827
247703 1184I72 ST-1091
247946 1248AA5 BLACK
247946 1248AA5 BROWN
247772 1189AY6 ST-1089
247893 284AD4 ST-857
247893 284AD4 ST-23
247893 284AD4 ST-529
248143 1248AD4 BLACK
248143 1248AD4 HTR/GRY
248110 1184DG7 ST-827
248110 1184DG7 ST-823

Sheet 2
STYLE# CUT# COLOR Yield
1184I72 247703 ST-1091 P 47.484
1184I72 247703 ST-1092 PLUS 47.484
1184I72 247703 ST-1166 PLUS 47.484
1184I72 247703 ST-529 PLUS 47.484
1184I72 247703 ST-827 PLUS 47.484
1248AA5 247946 BLACK PLUS 47.628
1248AA5 247946 BROWN PLUS 47.628
1189AY6 247772 ST-1089 PLUS 46.512
284AD4 247893 ST-23 PLUS 54
284AD4 247893 ST-529 PLUS 56.484
284AD4 247893 ST-857 PLUS 56.484
1248AD4 248143 BLACK PLUS 47.412
1248AD4 248143 BROWN PLUS 47.412
1248AD4 248143 H.GREY PLUS 47.412
1248AD4 248143 H.TAUPE PLUS 47.412
1248AD4 248143 NAVY PLUS 47.412
1184DG7 248110 ST-23 PLUS 50.904
1184DG7 248110 ST-827 PLUS ETC.




"DP7" wrote:

Sheet 1
CUT STYLE COLOR Yield
247703 1184I72 ST-827
247703 1184I72 ST-1091
247946 1248AA5 BLACK
247946 1248AA5 BROWN
247772 1189AY6 ST-1089
247893 284AD4 ST-857
247893 284AD4 ST-23
247893 284AD4 ST-529
248143 1248AD4 BLACK
248143 1248AD4 HTR/GRY
248110 1184DG7 ST-827
248110 1184DG7 ST-823

Sheet 2
STYLE# CUT# COLOR Yield
1184I72 247703 ST-1091 P 47.484
1184I72 247703 ST-1092 PLUS 47.484
1184I72 247703 ST-1166 PLUS 47.484
1184I72 247703 ST-529 PLUS 47.484
1184I72 247703 ST-827 PLUS 47.484
1248AA5 247946 BLACK PLUS 47.628
1248AA5 247946 BROWN PLUS 47.628
1189AY6 247772 ST-1089 PLUS 46.512
284AD4 247893 ST-23 PLUS 54
284AD4 247893 ST-529 PLUS 56.484
284AD4 247893 ST-857 PLUS 56.484
1248AD4 248143 BLACK PLUS 47.412
1248AD4 248143 BROWN PLUS 47.412
1248AD4 248143 H.GREY PLUS 47.412
1248AD4 248143 H.TAUPE PLUS 47.412
1248AD4 248143 NAVY PLUS 47.412
1184DG7 248110 ST-23 PLUS 50.904
1184DG7 248110 ST-827 PLUS 50.904


I need to match style, cut and color from Sheet one to Sheet two and
insert
the appropriate yield value from sheet 2 into sheet 1.



"Biff" wrote:

You need to post some sample data.

Biff

"DP7" wrote in message
...
I want to look up multiple values, to return only one value. So far I
have
only seen that I can use one lookup value in VLOOKUP. Is there any
way or
any
other function I should use to look up multiple values to return only
one
value? The multiple lookup values I want to use are not all in the
same
row.
The value to be returned is in the rightmost column.