When a particular code # is entered into B1, B2:B7 will have specific text and or numbers populate based on the code entered. Same would go for C1:F1.
So if the code number “100” is entered, the “IF” will trigger the name of the basket, page, and each of the fruits needed (cells B2:B7).
Each unique code number will populate specific to that code number as shown.
See attachment
Bookmarks