Easy Input

Discussion in 'Microsoft Excel Worksheet Functions' started by Ash, Feb 5, 2008.

  1. Ash

    Ash Guest

    I need to be able to input numbers or letters to assign to various plumbing
    fittings sizes and fittings. How would I do this? Which function, command,
    or macro do I use? I would assume to make a two column sheet with number on
    left and sizes and fittings on right column corresponding to each other, and
    having a function on my sheet lookup these values. This way I can input like
    a 5 for instance and press enter and it will then say like 3"x2".
     
    Ash, Feb 5, 2008
    #1
    1. Advertisements

  2. Ash

    T. Valko Guest

    See this:

    http://contextures.com/xlFunctions02.html

    --
    Biff
    Microsoft Excel MVP


    "Ash" <> wrote in message
    news:...
    >I need to be able to input numbers or letters to assign to various plumbing
    > fittings sizes and fittings. How would I do this? Which function,
    > command,
    > or macro do I use? I would assume to make a two column sheet with number
    > on
    > left and sizes and fittings on right column corresponding to each other,
    > and
    > having a function on my sheet lookup these values. This way I can input
    > like
    > a 5 for instance and press enter and it will then say like 3"x2".
     
    T. Valko, Feb 5, 2008
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sean Sydor

    I think this is an easy one - Year-to-Date Amounts

    Sean Sydor, Aug 22, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    206
    Paul B
    Aug 22, 2003
  2. Guest

    =SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF

    Guest, Mar 14, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    176
    Guest
    Mar 14, 2005
  3. Guest

    Prompt user for input and utilize that input

    Guest, Mar 28, 2007, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    274
    Guest
    Mar 28, 2007
  4. typographically challenged

    is there a quick easy way to input time?

    typographically challenged, Apr 16, 2008, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    185
    Gord Dibben
    Apr 17, 2008
  5. bsharp

    How to input pictures automatically based on cell input?

    bsharp, May 29, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    9
    Views:
    269
    Sheeloo
    May 30, 2009
Loading...

Share This Page