Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
I have tried looking in past entries and in excel help but I cant seem to
find the answers I am looking for. This is what I am trying to accomplish. I am trying to put together a searchable tool inventory. There are over 200 boxes of tools and many tools inside each box. I would like to put the tool# that I am searching for in cells B3-B12 and have the box# that the tool is in show up in C3-C12. Now here is another problem. I also would like to be able to click on the box# in C3-C12 and have it open up to the RIGHT like a drop box so I can see all of the tools in that box. 1 A B C D E F 2 TOOL# BOX# 3 Search for tool # 4 Search for tool # 5 Search for tool # 6 Search for tool # 7 Search for tool # 8 Search for tool # 9 Search for tool # 10 Search for tool # 11 Search for tool # 12 Search for tool # 13 tool# tool# tool# 14 BOX 1 t1 t2 t3 15 BOX 2 t4 t5 t6 16 BOX 3 t7 t8 t9 17 BOX 4 t10 t11 t12 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
Take a look at
http://contextures.com/xlDataVal02.html It may give you a better approach to what you are trying to do "mmcap" wrote: I have tried looking in past entries and in excel help but I cant seem to find the answers I am looking for. This is what I am trying to accomplish. I am trying to put together a searchable tool inventory. There are over 200 boxes of tools and many tools inside each box. I would like to put the tool# that I am searching for in cells B3-B12 and have the box# that the tool is in show up in C3-C12. Now here is another problem. I also would like to be able to click on the box# in C3-C12 and have it open up to the RIGHT like a drop box so I can see all of the tools in that box. 1 A B C D E F 2 TOOL# BOX# 3 Search for tool # 4 Search for tool # 5 Search for tool # 6 Search for tool # 7 Search for tool # 8 Search for tool # 9 Search for tool # 10 Search for tool # 11 Search for tool # 12 Search for tool # 13 tool# tool# tool# 14 BOX 1 t1 t2 t3 15 BOX 2 t4 t5 t6 16 BOX 3 t7 t8 t9 17 BOX 4 t10 t11 t12 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
Are the box numbers sequential from 1 to say 200? Can you give a few sample
box numbers? Also is there a limit to the number of tools in a box? Do the tools have names or numbers? A few sample pl. How about a matrix with box numbers down the row and tool numbers across column and having an X or YES if the tool is there in the box? Yes, you can build two drop boxes such that if you choose the box you can see the tool list for that box in the adjacent col... For details refer to http://www.contextures.com/xlDataVal02.html "mmcap" wrote: I have tried looking in past entries and in excel help but I cant seem to find the answers I am looking for. This is what I am trying to accomplish. I am trying to put together a searchable tool inventory. There are over 200 boxes of tools and many tools inside each box. I would like to put the tool# that I am searching for in cells B3-B12 and have the box# that the tool is in show up in C3-C12. Now here is another problem. I also would like to be able to click on the box# in C3-C12 and have it open up to the RIGHT like a drop box so I can see all of the tools in that box. 1 A B C D E F 2 TOOL# BOX# 3 Search for tool # 4 Search for tool # 5 Search for tool # 6 Search for tool # 7 Search for tool # 8 Search for tool # 9 Search for tool # 10 Search for tool # 11 Search for tool # 12 Search for tool # 13 tool# tool# tool# 14 BOX 1 t1 t2 t3 15 BOX 2 t4 t5 t6 16 BOX 3 t7 t8 t9 17 BOX 4 t10 t11 t12 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems With a Searchable Inventory Worksheet
I havent had much free time so it has taken me a while to look through and
attempt to digest the information. I think one of the answers is VLOOKUP it sounds like it is supposed to do what I am looking for but Im having a little difficulty understanding why it always returns the bottom cell for the column that is in the formula. Suppose range C14:F17 is named boxes and t2 is in cell B3. Shouldnt this formula =VLOOKUP(B3,boxes,1)return BOX1 since BOX1 is the first column in the row that has the match with B3? You can also look at the example that I pasted if you like. "Duke Carey" wrote: Take a look at http://contextures.com/xlDataVal02.html It may give you a better approach to what you are trying to do "mmcap" wrote: I have tried looking in past entries and in excel help but I cant seem to find the answers I am looking for. This is what I am trying to accomplish. I am trying to put together a searchable tool inventory. There are over 200 boxes of tools and many tools inside each box. I would like to put the tool# that I am searching for in cells B3-B12 and have the box# that the tool is in show up in C3-C12. Now here is another problem. I also would like to be able to click on the box# in C3-C12 and have it open up to the RIGHT like a drop box so I can see all of the tools in that box. 1 A B C D E F 2 TOOL# BOX# 3 Search for tool # 4 Search for tool # 5 Search for tool # 6 Search for tool # 7 Search for tool # 8 Search for tool # 9 Search for tool # 10 Search for tool # 11 Search for tool # 12 Search for tool # 13 tool# tool# tool# 14 BOX 1 t1 t2 t3 15 BOX 2 t4 t5 t6 16 BOX 3 t7 t8 t9 17 BOX 4 t10 t11 t12 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3D reference question in inventory Worksheet | Excel Worksheet Functions | |||
I am looking for an excell worksheet for restaurant inventory | Charts and Charting in Excel | |||
Creating an inventory worksheet | Excel Discussion (Misc queries) | |||
how do i set up a worksheet to calculate the inventory? | Excel Worksheet Functions | |||
Searchable Database | Excel Worksheet Functions |