You should have seen the colored boxes around the look-up table shift one cell down every time. Repeat Steps 1-6 for the remaining cells. (Pay close attention to the colored boxes.) Watch it in action:Ĭlick on the Input Line. OPENOFFICE CALC TUTORIALS SOFTWAREWhy do two cells contain #N/A? When you copy formulas in a spreadsheet, the software tries to help out by changing the cell references to maintain the relationships between the cells and the formulas. Select B1 again and drag the formula to B5. (AutoFill from 1 to 5.)Įnter Green in F11, Orange in F12, Purple in F13, Red in F14, and Blue in F15.Įnter 5 in A1, 4 in A2, 3 in A3, 2 in A4, and 1 in A5. It can be a cell reference, regular expression (if you don't know what regular expressions are, the on-line help can help you), or a value that is "hard-wired" into the formula (hard-wired means the data is entered as part of the formula and cannot be changed without editing the formula).ĭrag E11 down to E15. The Search criterion is the "topic" you are looking for. LOOKUP( Search criterion Search vector result_vector ). LOOKUP uses the same principle to retrieve values from a list. What do you do when you want to find a topic in a book? You go to the book's index, look up the topic, and get the page number. This tutorial will give you the basic tools advanced tools will come through practice and application. That's why you need a toolbox of methods to extract the information you want from any data set. There will be times when you can change the data configuration there will be other times when you can't make any changes. You will discover that data is not always organized in the optimum configuration for looking up values. The spreadsheets you create/use will become more complex as your skills develop. The first three functions are obviously look-up functions the last three are not so obvious. But it is probably causing a few headaches. Note: This change in 3.2 really is a proper approach to databases having mixed types is not proper database structure. If there's no data the field won't take up any room, and only the correct field will show. Then for your mail merge put both the fee and the applicable or not fields next to the Fee prompt. OR do this, which is workable but a bit more complicated. Just put in 0, or just blank, instead of N/A So: in the scenario I outlined you could: Here's what is in the database, and therefore what a mail merge would have access to. Here's an example of some test and screen shots I took. You can have all text, like N/A, or all numbers like 12, but not both. So your data might look like this:īUT that will not work because mail merges as of 3.2 (possibly earlier) don't like you to mix your types of data in a column. But let's say that sometimes there's no fee, perhaps organizations don't need to pay for cat licenses. Your mail merge document, with the various prompts and the field names, would look kind of like this: You'd put together the spreadsheet data kind of like this, then create a database based on that spreadsheet. Let's say you're putting together a mail merge listing the fees people in the county have to pay for getting their new cat license.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |