Lookup part of a cells contents
Hi,
I am trying to pull data from a list based on the results of an input
box.
The example is, I have a list off accounts "Acme1234", "AAA 3456",
"A-1 7890" etc. This list is completely variable based on account
manager.
I want to create an inputbox where I would key in "3456" and I would
get a popup messagebox that has AAA 3456 as well as several pieces of
information in that row on my spreadsheet.
Any help, as always, is appreciated.
Glen
|