SUMIF / Text

%3CLINGO-SUB%20id%3D%22lingo-sub-2719592%22%20slang%3D%22en-US%22%3ESUMIF%20%2F%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719592%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20screenshot%201%20I%20have%20a%20master%20product%20sheet%20containing%20Column%20%22COO%22%20in%20column%20AC.%20On%20the%20second%20screenshot%20I%20have%20a%20list%20of%20wholesale%20orders%20per%20product.%20On%20this%20page%2C%20%22Split%22%2C%20I%20am%20trying%20to%20obtain%20the%20COO%20per%20product.%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-09-04%20at%2012.12.00.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308130iA4B6FEC430D30EC2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-09-04%20at%2012.12.00.png%22%20alt%3D%22Screenshot%202021-09-04%20at%2012.12.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-09-04%20at%2012.12.10.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308131i8A4362360E4E4A73%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-09-04%20at%2012.12.10.png%22%20alt%3D%22Screenshot%202021-09-04%20at%2012.12.10.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2719592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719609%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20%2F%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146555%22%20target%3D%22_blank%22%3E%40JOESANDERS95%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20AI2%20on%20Split%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(VLOOKUP(A2%2C%20Images!C%3AAC%2C%2027%2C%20FALSE)%2C%20%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2726569%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20%2F%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2726569%22%20slang%3D%22en-US%22%3E%3CP%3EHans%20its%20VLOOKUP(A2%2CImages!B%3AAC%2C%205%2CFALSE)%3CBR%20%2F%3EYou%20need%20a%20bigger%20magnifying%20glass%20lol%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2727814%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20%2F%20Text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2727814%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou're%20correct%20that%20the%20range%20should%20start%20in%20column%20B%2C%20but%20that%20means%20the%20column%20index%20should%20be%2028%2C%20not%205.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

In screenshot 1 I have a master product sheet containing Column "COO" in column AC. On the second screenshot I have a list of wholesale orders per product. On this page, "Split", I am trying to obtain the COO per product. How do I do this?

Screenshot 2021-09-04 at 12.12.00.png

Screenshot 2021-09-04 at 12.12.10.png

6 Replies

@JOESANDERS95 

In AI2 on Split:

 

=IFERROR(VLOOKUP(A2, Images!C:AC, 27, FALSE), "")

 

=IFERROR(VLOOKUP(A2, Images!B:AC, 28, FALSE), "")

 

Fill down.

Hans its VLOOKUP(A2,Images!B:AC, 5,FALSE)
You need a bigger magnifying glass lol

@Yea_So 

You're correct that the range should start in column B, but that means the column index should be 28, not 5.

@Hans Vogelaar 

 

Yes you're right its the 28th column in the lookup range, I was counting the columns without realizing the columns F:AB were hidden.

@Yea_So 

Would you like to borrow my magnifying glass?

lol