I Am ReSpOnSiBlE fOr .........WhAt I aM...........wHaT i Do.....WhAt I hAvE

I have 3 columns A B C D 11H 3HI xyz 2AB 2CD dfd 3HI 11H 123 I would like to compare column A & B and if matched the adjucent cell value should be written in column D. For example A B C D 11H 3HI xyz 123 2AB 2CD dfd --- 3HI 11H 123 xyz. Answer: The formula we're after is: =VLOOKUP(A1,$B$1:$C$3,2,FALSE) Here's an image. Always show your attempts. We tend to help those who have attempted to help themselves more. However, if the dashes are a must instead of the #N/A in D2, then this is the formula =IFERROR(VLOOKUP(A3,$B$1:$C$3,2,FALSE),"---")

It usually occurs when keeping two office suites of different versions.   If you have two versions of Microsoft Word installed on the same computer, you experience a delay when you start Word 2007. This behavior occurs because Word 2007 auto-registers itself on the computer. Bypass the auto-registration for Word 2007, follow these steps: Exit Word 2007. Start Registry Editor. In Windows Vista, click  Start , type  regedit  in the  Start Search  box, and then press ENTER.  If you are prompted for an administrator password or for a confirmation, type the password, or click Continue . In Windows XP, click  Start , click  Run , type  regedit  in the  Open  box, and then click  OK . Locate and then click to select the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Word\Options After you select the subkey that is specified in step 3, point to  New ...

Symptoms Excel 2007 randomly crashes and/or hangs. Resolution Look for addins or Com Addins. For Addins: 1. Start Excel>do an Alt-F11, which will take you to the VBA Editor Window. >Do a CTRL-R which will take you to Project Explorer. >In Project Explorer, there should be only one Progect (Book 1). >If there are additional projects, we will need to remove them. 2. Go back to Excel, and select the Office Button > Excel Options >Addins > Manage >Excel Addins > Go and unselect all addins that are checked. While in Excel Options, Select Advanced > General > “At Startup open all files in “ and make sure this box is blank. 3. Go to C:\Program Files\Microsoft Office\Office 12\XLStart and remove any files in this directory for XP >Go to C:\Documents and Settings\<user name>\Application Data\Microsoft\Excel\XLStart  and remove any files in this directory. for Windows 7  C:\Users\<user name>\App...

This page describes how to diagnose and fix errors that may occur during start up:- Isolate The Scope Of The Problem The first step in any sort of troubleshooting is to isolate the scope of the problem. Does the problem occur only with a specific workbook? If so, you can focus your efforts on determining what is wrong with that specific file. Possible causes may be that the workbook file has become corrupted or is nearing a corrupt state. Or, it might be related to code in the workbook that automatically executes when the workbook is opened (via either an Auto_Open procedure or the workbook's Workbook_Open event procedure in the ThisWorkbook module. Start Excel In Safe Mode When you run Excel in Safe Mode, Excel does not open add-ins or other startup files. It is a clean no-frills mode of operation with many options unavailable. To run Excel in Safe Mode, go to the Windows Start menu, choose Run, and enter Excel.exe /safe You may need to enter the entire path to Exce...

you have ever tried to open an excel document and received the error that says " There was a problem sending the command to the program ", you can fix it by doing the following: Open Excel 2007 Open the Menu in the top left Click the "Excel Options" button Click the advanced tab on the left of the options screen Under the general options uncheck the box "Ignore other application that use Dynamic Data Exchange (DDE)"