sumif + vlookup maybe need to do a cross with hlookup

[garciapliz]

Hello Excel Forum Community,
I have searched through the forum threads and not seeing something that could help me with my current dilemma.

I have one workbook that contains 2 worksheets and am using a formula on the first sheet to have it put a yes or no depending on the frosting selected. As you'll see the formula just checks for a number so in instances in which it has 74 it'll put a yes in both under 7 and 74. What do I need to fix here?

For the cake portion I want to put a yes or no depending on the type of cake that it correlates with on the second sheet. The formula there is not working as I'm obviously missing a parameter but I am not sure how to structure.

Any advice is greatly appreciated. I apologize if this has been answered by piecing multiple threads.

Thanks,
Liz

[estige]

Hi, maybe use a simple "IF" instead of searching for the values in row 2? In Datasheet I6: =IF($D6=I$2,"Y","N")

[garciapliz]

Thank you for the simpler formula, however Excel is complaining that it is an "inconsistent formula".

Do you have an idea possibly for what the formula could be for cells S7 through W7? A Y would be in both T7 and W7.

Enjoy the weekend!

[Ace_XL]

In H3
=IF($D3=H$2,"Y","N")
Copy down and across

In S3
=INDEX(Cake!D$3:D$11,MATCH(INDEX($H$1:$P$1,MATCH("Y",$H3:$P3,0)),Cake!$B$3:$B$11,0))
Copy down and across

Ensure 'calculation' is set to 'Automatic', currently its 'manual'

[garciapliz]

Thank you Ace_XL! That worked