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