Multiple “IF” formula needed
I am cataloging all of our fruit baskets. Sheet1 “Catalog” lists each basket with a reference code, basket name, page number, and a particular number of fruit needed for that basket.
Sheet2 “FruitCount” is where I would enter the Code into cells B1:F1
When the code is entered I need the other cells in that column to populate the additional information based on that particular code entered.
If I entered “100” into B1, then B2:B7 would populate as shown and so on.
See attachment.
Bookmarks