View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
willb willb is offline
external usenet poster
 
Posts: 2
Default How can I have have one column's input depend on the variables in a second one?

I would like to have a set of names assigned to certain numbers for inventory
purposes, such as, each time that '12345' is typed in any row in the first
column the corresponding row of the second column will say 'Product A.' It
would also have to respond in such a way that if '34567' is typed in the same
location, 'Product D' would be displayed.

Thanks for any help.