View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gmunro gmunro is offline
external usenet poster
 
Posts: 34
Default 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