Results 1 to 14 of 14

Using Drop Down Menu to refer to other cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2010
    Location
    beds
    MS-Off Ver
    Excel 2002
    Posts
    9

    Using Drop Down Menu to refer to other cells

    Hi guys (and gals?)

    I have a drop down menu, and with a range from A-L each letter referring to different cells (its a list of dates) on the same sheet. I want to be able to let the user select A-L and when they make that selection it displays cell X (X being a cell that is on the same sheet) in another cell. For example (and I realise this is not a langauge but)

    If user=A show B1 in C7, if not
    if user=B show B2 in C7, if not
    If user=C show B3 in C7, if not

    etc etc

    Any Ideas

    Massive thanks in advance
    Last edited by NRD; 03-22-2010 at 04:18 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1