I have started to create excel search index (like in a library) but have over thought it. Im trying to get back on track here. I am thinking that a "match, index" function might work but I may not have it setup right?
Problem:

1) I have a Library index that is just messed up(things are organized by multiple persons with multiple agendas)

2) Want to just enter a "name" of item and it will give me a location in library to go and find it.

3) Need to create a digital search of the index, but what are my choices, vlookup or tables or something easier.

I have attached my progress

Looking for fresh ideas to start over.


any ideas are welcome, don't be afraid to say some think.

Attached Files

rev. 3.xlsx (45.4 KB, 10 views)