How to INDEX to pull a set of information from a separate sheet

Krystal Swed 0 Reputation points
2025-05-13T14:20:45.0366667+00:00

I am creating a Food cost workbook to be able to price out ingredient and have a sheet that you select the ingredient item, how much you are putting in the portion and it projects the cost for that amount you are inputting.

I have already checked the results and formula on where the amounts are being pulled from and those are correct but when I input this formula into the recipe cost sheet to cost an entire recipe menu item it is not pulling the correct information.

Screenshot 2025-05-13 at 9.39.19 AM

Screenshot 2025-05-13 at 9.38.44 AM

Screenshot 2025-05-13 at 9.38.08 AM

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,939 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Barry Schwarz 3,746 Reputation points
    2025-05-13T21:36:27.3966667+00:00

    Answered in your subsequent post.

    0 comments No comments

  2. Barry Schwarz 3,746 Reputation points
    2025-05-13T21:37:19.79+00:00

    Answered in your subsequent post.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.