help with INDEX MATCH MATCH

[Greg Thompson]

=(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.

[#2]

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)),"")

[#3]

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

[#4]

Greg, please check attached

[#5]

Excellent thank you Sir   what did I do wrong?

[#6]

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.

[#7]

I C I probably couldnt see the trees for the forest.