Forum Discussion

Greg Thompson's avatar
Greg Thompson
Copper Contributor
Jun 28, 2018

help with INDEX MATCH MATCH

=(IFERROR(INDEX(MasterPricingSheet!$A$2:$S$112,MATCH(RecipeInputPage!C2,MasterPricingSheet!$A$2:$A$112,0),MATCH(RecipeInputPage!D2,MasterPricingSheet!$A$4:$S$4,0)),""))     I entered this in Column "F" to get a return from Column D2 and C2.  However Nothing comes back.  I am trying to pull info from MasterPricingSheet.     I am pulling my hair out what is left lol.   Any help would be appreciated.

Formulas & Functions
Need Help

6 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 28, 2018

    Hi Greg,

     

    Change second MATCH (columns) from

    MATCH(RecipePageInput!D2,MasterPricingSheet!$A$4:$S$4,0)),"")

    on

    MATCH(RecipePageInput!D2,MasterPricingSheet!$A$2:$S$2,0)),"")

     

    • Greg Thompson's avatar
      Greg Thompson
      Copper Contributor
      Jun 28, 2018

      I tried what you suggested I got a typo error and it fixed automatically, but the info never came up.

       

      this is what i have now

       

      =(IFERROR(INDEX(MasterPricingSheet!$A$2:$S$112,MATCH(RecipeInputPage!C2,MasterPricingSheet!$A$2:$A$112,0),MATCH(RecipePageInput!D2,MasterPricingSheet!$A$2:$S$2,0)),""))

       

      and thanks in advance for your help

Resources