homebuilder
New Member
- Joined
- May 7, 2002
- Messages
- 5
Is there a way to reference multiple values without using a nesting IF function?
On 2002-05-08 13:46, homebuilder wrote:
Let me clarify:
our internal codes for subdivisions are not known to vendors and subcontractors, who I am in constant contact with. Instead of handwriting the full name, I would like to enter the code in a cell and have it return the full name to a form that will then be sent to the vendor.
example:
ams02, bgr12, cfs06 - enter any of these into one cell and have the appropriate name returned to another
Ada Moorings, Bailey's Grove
This will save me at least an hour a day.