Can I Save the "Find" Option Settings?

I have an excel file saved on my company server. Each desktop in the company has it's own excel file that uses vlookup to pull information out of that file. Unfortunately, I cannot then use the "find" fuction as it is searching the vlookup formula, and not the actual value displayed.

To fix this, I go to find, click options, and tell it to "look in" values, rather than formulas.

The problem is that everytime someone opens this excel on their desktop, they have to edit their find options. Can the find options be saved? In otherwords, I need excel to know to look it "values" and not formulas, without being having to tell it everytime.

I have several work arounds, but I'm looking for an automatic solution... like "SAVE SETTINGS"

Thanks in advance!

So if I undestand you correctly, you can say that I can use the formula and "encode" a particular term into it? Or something similiar?

Unfortunately, I think I may have mis-stated my problem just slightly. I am using an excell with several tabs, and vlookup is being used on other tabs- this particular tab is simply reading information from the server file. It's using an = formula (i.e. )'=\\server\file location\[file name]tab'!Cell)

Here is my application for this particular tab. We have an excell of inventory items that are formatted in two columns. The first column is a "short code" while the second column is the full description. For instance, the short code may be "BB3", and the full description may be , "3" Binder, Blue, Part # 87354".

For obvious reasons, we use the short codes a lot, and when the operator needs to see what the short code's full description is, they simply search the short code (via FIND), and the cell next to it has the full description. However, this list changes a lot, and rather than update every computer each time, I update the server, and use the = funtion to updates each desktop's excel.

With this setup, is there a way to incorporate the "short code" into the forumula? Would you be able to demonstrate what such a formula would look like? Our excell currently has 7,000 unique short codes.

Thanks!

Just another thought on this.. is there a copy/paste special formula? I could tell it to copy cell A1 and paste/special/values into another field?

What type of code would I be looking at? I've never had to do anything like that, but would be willing to google help if I know where to look.

We actually have that done very thing on another tab. Unfortunately, while that is all some operators need, other operators need the ability to do a partial search and then to do a little browsing. The short codes are categorized, which makes this possible. Thanks for your thoughts and I'm hoping you get a light bulb moment!

I do not have a table for the codes. Would you be able to provide or point me to something of this nature?

Sorry, I mustunderstood.

I have a list of all the codes and descriptions in one excell file. Two columns of approx 7000 rows. This is a complete list, and all operators use the complete list. Hope this better answers your question.

It sounds as though that may be a viable option, unfortunatley, to be blunt, I dont know how to make an add-in, and I dont know if I would have it make a text/list box or if that's just in it. I don't fully understand the lingo here. I have not gone much beyond vlookup, but feel confident that I can, I simply have not had occasion to. Is there a help manual that I could use to work my way through it? I would require something that is somewhat step by step. If there isn't anything like this, I understand. Thanks again!