Forum Discussion

JOESANDERS95's avatar
JOESANDERS95
Copper Contributor
Sep 04, 2021

SUMIF / Text

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?

 

 

excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 04, 2021

    JOESANDERS95 

    In AI2 on Split:

     

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

     

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

     

    Fill down.

    • Yea_So's avatar
      Yea_So
      Bronze Contributor
      Sep 07, 2021

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

      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Sep 07, 2021

        Yea_So 

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

Resources