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".

See this:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"Ash" <(E-Mail Removed)> wrote in message
news:A7CC61B4-BD0F-4B20-87E8-(E-Mail Removed)...
>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".