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.