formula LOOKUP (= 1,0 / (transcript! A $2: A $5 = B2), result table! C $2: C $5). Struggling to find the data column appeared # N/A, the impact of the form is beautiful. Improved slightly once, use ISNA function to decide whether it is for # N/A, if yes, set to null. Microsoft Office 2010 is so great.

In many cases we in Excel the cell containing the input data is fixed content, such as from the same area county the id number before 6 digit must be the same, or from the same city &county person the contact address city and county part is fixed. This kind of circumstance, if honestly please input, the efficiency is very low. How to quickly and accurately input these contain fixed content data? The following a few methods I must have a can help you solve the problem.

Office 2010 is my favorite.

If the data containing fixed content, but also has a pattern of data, such as unit staff employee Numbers, in some sort of way, they are a regular sequence. This case the most simply the most direct way is to use automatic filling.

For instance need to input data is "showing separately F.O.B value subjcet x", after four different, the top five data are the same. So we need only in the first, second and third respectively input "cell 123450001", "123450002", "123450003", then select the three cell and drag the cell regional fill handle to drag down to the place, he can complete automatic filling.

If fixed content for the text, but as long as the digital parts for regular sequence, such as "a workshop 001", "a workshop 002" etc, also can use this method.

Setting cell format Microsoft Office is helpful.

If need to input data cannot automatic filling, then we can use the Settings cell format to simplify our work. For instance need to input data is a group of 14 figures, which are "top ten 0737070680", only after four different. By setting a cell format, you can only enter 4 digit, let the top ten digital automatically add. Outlook 2010 is powerful.

Realizing method is: select the data in the cell area, then click right, and on the shortcut menu, select "Settings cell format" the order, opens "Settings cell format" dialog box. In a "digital" TAB "classified" list click "customization", then at the right of "the type" input box type "0737070680000 #" (excluding quotes), i.e. input front common parts, after the first three four input "0", and the fourth input "#". Such input as long as the cell direct input "1", "2", "3" wait, can directly complement for 14 digits. Microsoft outlook 2010 is convenient!

If the data contained in the text, such as fixed before a few word is "of weifang city", so we can also in this custom "type" input box type "" of weifang city" @ ". After input this a few word can automatically add. This method is displayed on the screen is all data, but we can click the cell in the edit column see actual data we just manual entry section. Office 2007 can make life more better and easier.