Inventory template

Question

I need help with inventory products. In excel I have 2 sheets. First sheet is template, where I want to enter number of room lets say 400 in one cell like b3. After i enter number in cell b3 i want inventory products, like pc, desk, chairs automatically display under in template that i create based on room number. Second sheet is my data base with all inventory products organized by room and inventory number.

Answer 1

@Mate Majić

You could use INDEX function.
Here is my test.
Data is listed as below in Sheet2.

In Sheet1, I used =VLOOKUP(A2,Sheet2!A2:F9,2,FALSE) in cell B2, =VLOOKUP(A2,Sheet2!A2:F9,3,FALSE) in cell C2 and so on.

Then you could change the number in A2 to you want.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.