look up multiple values, to return only one value

G

Guest

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.
 
G

Guest

the experts might need to add to this, but I know you can use vlookup in this
scenario, it goes something like this:

=vlookup,A1+B5+C8,value of destination cell,0,1)

so just use the + sign to look for multiple values.

Sorry for lack of detail, I can do it better than I can explain it.
 
G

Guest

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.
 
G

Guest

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.
 
B

Biff

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
 
G

Guest

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
 
B

Biff

If you want to, you can send me a copy of your file so I can see what's
needed. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top