Greetings, I am new to this list. If this question was recently asked, please point me to it and forgive me for asking it so soon.
I want to make an Excel table to do a task. I want a drop down (I know how to use Data valadation with a list) where a user will pick a word in the drop down, and in another cell, an alpha-numeric part number will be the result. I have 20 or so part numbers, so a simple "IF" formula will not work, or if I could use it, it would very hard to make them over and over, and hard to edit. Here is sample: Drop down: Result: BHSCS AES18 SHCS AES14 FHSCS AES16 HHCS AEB02 Shoulder Soc. Cap Screw AES20 Soc. Cap Set Screw AES32 SAE Flat Washer AEW24 Std. Lock Washer AEW07 HI Collar Lock Washer AEW10 Hex Nut AEN04 Hex Jam Nut AEN05 Dowel AEP05 Roll Pin AEP23 Can this be done in Excel without a macro, API, VBA? I have been reading the help file for hours. Thanks for any help you may give me. Dan Rochester Hills, Michigan --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
