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 "...
Formulas & Functions
Need Help
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

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

        Excellent thank you Sir   what did I do wrong?