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
MVP

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?

       

      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Jun 28, 2018

        Greg, you are welcome.

         

        In your formula in first MATCH is wrong sheet name - RecipeInputPage. It shall be RecipePageInput. Have no idea why that appered.

Resources