# question

0 Votes"
asked commented

## Inventory template

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.

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

### 1 Answer

0 Votes"
answered commented

@MateMaji-1587

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.

image.png (54.9 KiB)
test.gif (94.3 KiB)
image.png (51.9 KiB)
· 2

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for answer.

I found solution on YouTube and used MATCH and INDEX functions.

It works perfectly for my problem.

If anyone have same problem the name of video is "Find Multiple Match Results in Excel" by Leila Gharani.

Once again thank you for answer.

0 Votes 0 ·
MateMaji-1587

It's my pleasure to help.
I'm happy to hear that your issue has been resolved.
Also thanks for sharing.
Have a nice day~

0 Votes 0 ·