IF functions

[homebuilder]

Is there a way to reference multiple values without using a nesting IF function?

 

[Mark W.]

VLOOKUP, CHOOSE, MATCH
This message was edited by Mark W. on 2002-05-08 13:37

 

[homebuilder]

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.

 

[Mark W.]

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.

=VLOOKUP(A1,{"ams02","Ada Moorings";"bgr12","Bailey's Grove";...},2,0)

or...

=VLOOKUP(A1,B1:C10,2,0)

...where B1:C10 contains...

{"ams02","Ada Moorings"
;"bgr12","Bailey's Grove"
;...}

 

[James]

Hi HomeBuilder,

I can send you an example file, Let me know

James