LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Text to Columns" for many columns in Excel 2003 NickName Excel Discussion (Misc queries) 12 September 8th 06 10:14 PM
Counting values for variables in separate columns MMcQ Excel Discussion (Misc queries) 6 August 30th 06 12:28 PM
Merging two columns and keeping the data from both Stosh Excel Worksheet Functions 9 July 27th 06 06:48 PM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"