question

MateMaji-1587 avatar image
0 Votes"
MateMaji-1587 asked erinding-msft 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.

office-excel-itpro
5 |1600 characters needed characters left characters exceeded

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

1 Answer

erinding-msft avatar image
0 Votes"
erinding-msft answered erinding-msft commented

@MateMaji-1587

You could use INDEX function.
Here is my test.
Data is listed as below in Sheet2.
82239-image.png
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.
82278-image.png

Then you could change the number in A2 to you want.
82297-test.gif


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
5 |1600 characters needed characters left characters exceeded

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 ·

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 ·