Any excel Gods out there? Probably easy to do, but I cant figure it.
I have a worksheet containing a large number of chemical names, in the next column is a unique reference number. Is there any way I can search the names and return the number? The problem is that I want it to list all the instances of the name. So if I search for alcohol, it will find industrial alcohol, methly alcohol, etc, and display all the reference numbers next to the names.
It also needs to be easy to use so that I can email to other people. SO some kind of report view.
Cheers
Jon


LinkBack URL
About LinkBacks
Reply With Quote