IF or SUMIF to bring back text?

I am trying to match departments which have two different titles.  For 
example, there are 50 departments that are futher classified into 150 
sub-departments.  I do have the data showing departments and their 
corresponding sub-departments in two columns.  On another sheet there are 
only sub-departments and I need to assign the corresponding department name.  
I have tried IF and SumIf but neither works.   Basically, I need a formula to 
match the text and bring back the text for the sub-department.  
Thank you.
0
Utf
4/6/2010 7:14:21 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
940 Views

Similar Articles

[PageSpeed] 33

sounds like you need VLOOKUP

"Valerie" wrote:

> I am trying to match departments which have two different titles.  For 
> example, there are 50 departments that are futher classified into 150 
> sub-departments.  I do have the data showing departments and their 
> corresponding sub-departments in two columns.  On another sheet there are 
> only sub-departments and I need to assign the corresponding department name.  
> I have tried IF and SumIf but neither works.   Basically, I need a formula to 
> match the text and bring back the text for the sub-department.  
> Thank you.
0
Utf
4/6/2010 7:38:01 PM
Reply:

Similar Artilces:

do you know commands for when importing text file into visio 2000
Hi, I am trying to create visio file by importing *.csv files into visio 2000. I have had limited success, but I want to connect the shapes--from the stencil sheets--together. Does anyone have any documentation about this? From the basic flowchart stencil sheet, i can link together two process shapes with a connection. But I do not know how to connect an annotation shape to a process shape. I also do not know how to put two words on different lines for an annotation shape. I know it's confusing, but I have an example of what I am trying to do. The following is a *.csv text file. Put...

Automatic Text to column
::Is there any trick by which the text is automatically separated to th adjacent cells. i.e. the text seperated by \" , \" is automatically spreaded t the adjacent cells as soon as entered. without using the text t column fuction. Please mail me at *dinesh.vijay@gmail.com*: -- dines ----------------------------------------------------------------------- dinesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2417 View this thread: http://www.excelforum.com/showthread.php?threadid=37798 You might be referring to this issue: http://support.mi...

SMTP to certain domains bounce back as relaying attempts
Hi I'm running a Win2K, Exchange 2000 SP3 server farm with 2 different email domains hosted. I have a problem only when my users send out bulk BCC'ed PDF attachments to a large number of recipients (200-300). 90% of them get delivered but 10% will be returned with various errors like "Relaying denied" "Security policy would prevent this", "no permission to send to this recipient", "Invalid domain company1.com". If I take the addresses that failed and personally send them an email, it always works. Even if I send it to them as a BCC!! In all ...

Text Lists
Let's say I have several rental houses. Column "A" lists house names from a guest survey. Column C lists Comments on the house from a guest survey. On a seperate worksheet, I want to type in the name of a house, and have excel list all the comments that pertain to that house. Take a look at using Advanced Filter. Plenty of good guidance at http://www.contextures.com/xladvfilter01.html -- Regards Roger Govier "Jaytee" <Jaytee@discussions.microsoft.com> wrote in message news:421ED165-8FD1-4ED5-A01E-54BA10A5BEB3@microsoft.com... > Let's say I have sever...

Take the space out of text?????
I have exported some information into a excel spreadsheet that I will be importing into another program. Unfortunately one of the colums has a space between the text that I need to remove. Example: how cell looks now: abcde fghij how I need it to look: abcdefghij Unfortunately it is not a small worksheet. It has 5863 rows that need to be changed. PLEASE!!!! PLEASE!!!! HELP!!!!!! If anyone can help I would greatly appreciate it!!!!!!!!! Thank you, Nichole --- Message posted from http://www.ExcelForum.com/ Hi you have already posted this. Have you read the answers ?? -- Regards Frank...

Changing or removing '($)' text which is appended to currency field labels.
Hi all Does anyone know of a way of achieving either of the following: 1. Change the ($) text which is automatically appended to currency field labels to ($000) ONLY for specific money fields (not all). I know the global setting can be changed under System Settings, but this is not appropriate. 2. Prevent the ($) text from being appended altogether to currency field labels. Unfortunately, setting the currency symbol to an empty string under System Settings still results in () being appended to the money field labels. Thanks Andrew ...

Text colour for certain words ?
I have an Excel database, how can i get excel to mark every instance of a certain word in red ?? I know there must be a way, but i'm not very excel literate yet ! Cheers Andrew put a heading(e.g. "name") to the column . highlight the column- cick data-filter-autofilter. click arrow at right bottom of "name"-in the list that pops up click the particualr word or string. Now you will get only those cells which have this particular word or string. highlight visible cells and mark red using drawing toolbar. again click data filter autofilter. now the filter is r...

Customer account with overcredit wants money back
How do I make a transaction where I return a customer the money in his favor that he has on his customer account. Thanks Valentin If you're going to hand over cash from the till, use the Payment feature and enter a negative number in the amount field. If you're going to write a check, you can make an account adjustment on the Customer properties Account Information tab. HTH, Tom "Valentin Sosa" <ValentinSosa@discussions.microsoft.com> wrote in message news:5FB4B733-FF4C-47D2-81C0-B2AF6221E70D@microsoft.com... > How do I make a transaction where I return a ...

Importing Text Files #2
Anyone know how to create an overflow for text files? I import massive amounts of data from a text file into Excel, and I always must do this several times after opening text file and deleting top 62000 lines. I found a macro online once, and had it set up on my computer, but have since reformatted and lost the macro. Anyone know where to find this macro again? Or know how to force the import to continue on a second sheet? THank you in advance for any help..... Adam HI, Play with this code - it'll ask you how many lines to put on a page before adding a new page and filling it u...

Exchange 2003 Front End/Back End Servers & Passwords
Hi Been running Exch 2003 internally and would now like to put a front end server in a DMZ to allow external access. As we have a small & trusted team we have simple passwords for the internal LAN logon which wouldn't be suitable for external access. My question is can I have robust passwords for logging onto the front end server, whilst keeping the simple passwords for internal logins thanks Peter Peter Marshall wrote: > Hi > > Been running Exch 2003 internally and would now like to put a front > end server in a DMZ to allow external access. > > As we hav...

Outlook does not find Notes by Cyrillic text in them
Hello Outlook 2003 sp1 and 2002 sp2 do not find Notes by Cyrillic text in them, only by Latin text and digits. How to make Outlook 2003 sp1 find Notes by Cyrillic text in them? ������������ ������� Outlook 2003 sp1 � 2002 sp2 �� ������� ������� �� �������������� ������ � ���, ������ �� ���������� ������ � ������. ��� ��������� Outlook 2003 �������� �� �������������� ������? ...

pst: import of the back-up
I needed to reinstall Vista, so, using the (.pst) export file wizard, I backed-up a copy of my Outlook 2007 file. I reinstalled vista and Office 2007 and the only content I can access in Outlook are the Inbox and the sub folders. There are no contacts/calendar detail - which I'm not too concerned at. However, all the content from sent mail is missing - the folder is empty - does a .pst backup not include the sent mail? If the backup should include the sent mail, how do I access them? I've ran the repair tool but it's made no difference? Why would you export to ...

text message
I would like to have a girl friend who help or advise me to secced my intention thinks __________ Information from ESET NOD32 Antivirus, version of virus signature database 3599 (20081110) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com ...

Writing text on top of a pretty picture.
Instead of the typical windows background color, the powers that be want a pretty picture to be displayed. My dialog application also needs the functionality of an edit box, but I don't want an edit box with its clunky, white appearance covering up a portion of the pretty picture. If there's a way to make an edit box transparent....I tried that using edit box controls and it's still clunky white.... I use DIBSectionLite to draw the picture. Controls show up on top of the image - good. I set the background to transparent and do TextOut (in OnPaint.) This works when I put the code i...

Excel 2003: numbers copied from website are treated as text
I copied several columns of data (Verizon wireless detail data), and one column (minutes) is treated as text. I want to use the values in a calculation (summation), but that gives a data type error. The Help on converting numbers stored as text advises: 1. On the menu: Tools | Options | Error Checking 2. Make sure "Enable background error checking" and "Number stored as text" both Selected, click OK 3.On the worksheet, select any single cell or range of adjacent cells that has an error indicator in the upper left-hand corner *** no cells have an error indicator **...

Front End/Back End
Dear All, We have done setup exchange 2003 FE/BE and Front End is DMZ. The incoming mails coming to our domain will come to Front end and Front end is responsible to deliver to Mail Box Store which is on Back End Cluster. The Problem is when delivering from front end to back end Store its taking time about hours, mails in queue are getting stuck on front end while delivering to Information Store on BackEnd Cluster. Advanced Thanks,, Murali Have you opened ports in accordance with http://support.microsoft.com/default.aspx?scid=kb;en-us;280132 ? Also, MS does not recomm...

Can't open a Publisher 2K file in Publisher 2002, edit text only .
Why can't I open an existing Publisher 2000 file with Publisher 2002, then make minor text edits and re-save the file in Publisher 2000 without getting the error message, "There is a picture on page 1 that is too large to be converted to previous versions of Publisher." Publisher 2000 did not use compression... PUB2000: File Size Increases Unexpectedly When You Insert Picture http://support.microsoft.com/default.aspx?scid=kb;en-us;253973 -- Mary Sauer MS MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Art Frustrated with Publisher...

text box #5
How do I delete an empty text box? Hi David click on the border of it (so it shows little dots instead of little diagonals) and press the delete key. Cheers JulieD "DavidK" <DavidK@discussions.microsoft.com> wrote in message news:61C2D2F4-2F29-4FB0-B10E-A21DDEB72178@microsoft.com... > How do I delete an empty text box? ...

Null in text box
Can anyone see what might be wrong withthis procedure? Private Sub Job_Number_BeforeUpdate(Cancel As Integer) If IsNull(Me.Job_Number) = True Then MsgBox "No Job Number Entered" Cancel = True End If End Sub -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200707/1 "Haggr1 via AccessMonster.com" <u35393@uwe> wrote in news:74fa8171f7137@uwe: > Can anyone see what might be wrong withthis procedure? > > Private Sub Job_Number_BeforeUpdate(Cancel As Integer) > > If IsNull(Me.Job_...

font sizes for To, From, and Subject text boxes
How do you change the font sizes for these 3 textboxes when composing an email? When you set the fonts under Options->Mail Format, only the font in textarea for the message body gets changed. Thanks, Ernest Correct. That's what that setting is for -- to change the message font. If you want to change the font sizes of other elements, you'd have to design a custom form. In some cases, changing the overall Windows font size might also have an effect. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Dev...

access 2000 converting text to number format
a database in my office was created and the person who designed it put every field in a table as a text field. the numbers that are in those fields need to be change to a number to related to other tables. is there VB code or script to change it? or any other waY? Can you change the data type of the field to be Number? ...

Preview pane HTML text size too small.
How do I increase the text size of HTML messages in the preview pane? For that matter, can I increase the size of everything in general in the preview pane for HTML messages? Thanks. Mike;1255475 Wrote: > How do I increase the text size of HTML messages in the preview pane? > For that matter, can I increase the size of everything in general in > the preview pane for HTML messages? Thanks. 1. Click on "tools" 2. Click on "options" 3. Click on "read" 4. Click on "fonts" -- rhlhamlet On Apr 17, 9:19=A0pm, rhlhamlet &l...

mail merge inside text box.!
hi all! i am working in word2003. i am having a main document with address inside a text box..! while i am trying mailmerge for fields inside the address box i couldn't succeed..! my fields for address are in a seperate xl file.! how can i achieve this..? any hlp.? -via135 I've no idea -- works fine here. Of course I'm using the Mac version of Word, which is the group you've posted to. Things might be different in the Windows versions. I seem to recall something about fields in text boxes not working properly on the Dark Side but you'd do bet...

Access 2003 Sorting Text
I am looking for a way to order text numbers - similar to a number list order in Word i.e. - 1,1.1, 1.2, 2, 2.1, 2.2, 3 ... etc. These are item numbers in a procedure list that I want to show on a form or report in 'text' order. The problem is that the sort order 'reads' 2.10 (two decimal ten) as equal to 2.1 (two decimal one). Is there a routine for handling this sort? Any help would be appreciated. Cheers, -- BRich am not sure this is the reply you are looking for....but it seems like the field is defined as a number - if it dropping that 0; but could/should be ...

Replacing text based on a userform field
I've create a user form with multiple text fields. I'd like to use VBA to go find text in the document and replace it with what's in inputed by the User in the text fields upon clicking a button. Any help would be much appreciated. ...