Spreadsheet: 127553d1320407243-excel-2007-column-data-spacecodes
Sheet: spacecodes

Space Code | Space Discription |  |  |  |  |  |  |  | 110
110 | Classroom
115 | Classroom Service
210 | Class Laboratory
215 | Class Laboratory Service
220 | Open Laboratory |  | What I would like to do is have this where I enter the space code in a cell and in the adjacent cell it returns the applicable space discription based on the corresponding space code.  Let's just say that I want to put the space code in J2 and the space description in K2.  All I would like to have to do is enter the space code in J2 and a formula returns the space description in K2.  I can't do this with an "IF" formula because there are to many space codes and space descriptions.  Thanks for any help you can give.
225 | Open Laboratory Service
250 | Research/Nonclass Laboratory
255 | Research/Nonclass Laboratory Service
310 | Office
315 | Office Service
350 | Conference Room
355 | Conference Room Service
410 | Study Room
420 | Stack
430 | Open-Stack Study Room
440 | Processing Room
455 | Study Service
510 | Armory
515 | Armory Service
520 | Athletic or Physical Education
523 | Athletic Facilities Spectator Seating
525 | Athletic or Physical Education Service
530 | Media Production
535 | Media Production Service
540 | Clinic
545 | Clinic Service
550 | Demonstration
555 | Demonstration Service
560 | Field Building
570 | Animal Facilities
575 | Animal Facilities Service
580 | Greenhouse
585 | Greenhouse Service
590 | Other (All Purpose)
610 | Assembly
615 | Assembly Service
620 | Exhibition
625 | Exhibition Service
630 | Food Facility
635 | Food Facility Service
640 | Day Care
645 | Day Care Service
650 | Lounge
655 | Lounge Service
660 | Merchandising
665 | Merchandising Service
670 | Recreation
675 | Recreation Service
680 | Meeting Room
685 | Meeting Room Service
710 | Central Computer or Telecommunications
715 | Central Computer or Telecommunications
720 | Shop
725 | Shop Service
730 | Central Storage
735 | Central Storage Service
740 | Vehicle Storage
745 | Vehicle Storage Service
750 | Central Service
755 | Central Service Support
760 | Hazardous Materials Storage
770 | Hazardous Waste Storage
775 | Hazardous Waste Service
780 | Unit Storage
810 | Patient Bedroom
815 | Patient Bedroom Service
820 | Patient Bath
830 | Nurse Station
835 | Nurse Station Service
840 | Surgery
845 | Surgery Service
850 | Treatment/Examination Clinic
855 | Treatment/Examination Clinic Service
860 | Diagnostic Service Laboratory
865 | Diagnostic Service Laboratory Support
870 | Central Supplies
880 | Public Waiting
890 | Staff On-Call Facility
895 | Staff On-Call Facility Service
910 | Sleep/Study Without Toilet or Bath
919 | Toilet or Bath
920 | Sleep/Study With Toilet or Bath
935 | Sleep/Study Service
950 | Apartment
955 | Apartment Service
970 | House
50 | Inactive Area
60 | Alteration or Conversion Area
70 | Unfinished Area
W01 | Bridge/Tunnel
W02 | Elevator
[NAME] | Escalator
W04 | Loading Dock
[NAME] | [NAME]
W06 | Public Corridor
W07 | Stairway
X01 | Custodial Supply Closet
X02 | Janitor Room
X03 | Public Rest Room
[NAME] | Trash Room
Y01 | Central Utility Plant
[NAME] | Fuel Room
Y03 | Shaft
Y04 | Utility/Mechanical Space