SUMIF / Text

[JOESANDERS95]

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?

 

 

[#2]

@JOESANDERS95 

In AI2 on Split:

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

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

Fill down.

[#3]

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

[#4]

@Yea_So 

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

[#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.

[#6]

@Yea_So 

Would you like to borrow my magnifying glass?

[#7]

lol