If I have a spread sheet that I'm trying to put data into one column then it automatically updates the other column based on what I put into that column. Can I do that without an IF formula? I have to many fields for this to work with an IF formula. See the data below that I am talking about.
110 Classroom
115 Classroom Service
210 Class Laboratory
215 Class Laboratory Service
220 Open Laboratory
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
it's going to have to be an if formula, theres no other way around it. just open up wordpad and type it all out there, then copy/paste it.Originally Posted by rotella8
tip: type it in code style and then remove all the code format (returns and large spaces) to make it a LOT easier on yourself.
i think there are possibilities
upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Attached is a sample workbook with the description of what I need to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks