Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2009
    Location
    Chicago, Illinois, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an application that will use Data Validation to allow selection from a drop-down list. I'm okay with making the drop-down selection work, but I'd like to augment it if I can. I'm using Office 2000. Here's the deal:

    Let's say that the list itself has four entries--Alpha, Beta, Gamma, and Delta--in cells A1 through A4. Cells B1 through B4 have the numbers 1 through 4, so Alpha (cell A1) is alongside and associated with 1 (cell B1), Beta with 2, Gamma with 3, and Delta with 4.

    Column D has the cells that choose entries from the drop-down list, and I also want to put associated data into column E. For example, if I choose to put Alpha in cell D12, I also want the number associated with Alpha--the number 1--to automatically be put in cell E12. If I chose Gamma for cell D13, I want a 3 to be put in cell E13, and so forth. I don't see how to do this without a VBA script, and I'm hardly even at square one with VBA. Can anybody help?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can do this without VBA: enter the following formula in E1

    =IF(D1="","",VLOOKUP(D1,$A$1:$B$4,2,FALSE))

    and fill down as far as needed. See the attached sample workbook.

    [attachment=87332:ValidationFormulas.xls]
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •