Conundrum...

I have hit a wall...

I have several hundred boxes each with their own unique reference code.

Within these boxes there are documents, each with their own unique reference code.

I have created a database in excel (2003) comprising of the box reference codes as headers of columns with the document references below.

THE CHALLENGE!

To create a search function where the user would be able to type in a document reference code, the search function would then indicate which box that particular document is situated.

Please help!

Thank you for your time

Vishesh's picture

Upload the file to understand

Upload the file to understand it better. However, it seems you can use Hlookup formula here.