Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy Input
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". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Easy Input
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Ash" wrote in message ... 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". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
new user with easy question? not easy for me | New Users to Excel | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions |