Benefits of the VLOOKUP and the IF Formula in Spreadsheets

112.6 Respond to each post with no less than 150 words

I feel that the use of formulas is the one thing that I have done the least of in this program. I have found it to be a little confusing to configure t first until one gets use to how to do it. Once one learns how to do it, then there can be many benefits for using them that allows easier and faster creations of spreadsheets. The formula I chose to speak about that I never used before is the VLOOKUP, which looks for values in the left most column of tables and will return the value in same row you request it to be in It is helpful for looking for data and matches. If one table index, one can look at column A and return it to column B. One can also use the range look up with this that will give a true or false value. Doing it this way, “TRUE” can find the closes match if there is not an exact match and “FALSE” can find only exact matches. An example of using this formula would be the following: For instance, one may have two categories on their spreadsheet, one for sales with commissions for each employee and another for sales and the names of each employee. As an accounts payable representative, one may need to match the sales commissions with each employee name. Using this formula, it will allow one to match things up properly without error and less time consuming. The formula like this would look like: =VLOOKUP (B1, $A$3:$B13, 2, FALSE. The matches would then be done nice and neat without error.

 

112.6.2

 

I have a little bit of experience with a few formulas in Excel, such as average and vlookup. For this forum I chose the IF formula because it seemed like one that I may be able to use. The IF formula looks for a particular criteria that you identify and then returns a value that you assign whether it’s true or it’s false. For example, you can say if the value in cell A1 is greater than the value in B1, it’s true, then return “yes”, if false return “no.” The IF formula was not difficult to learn and in fact I used it today in a report that I analyze on a monthly basis. This report is several hundred rows and about twenty columns wide. I have to analyze and then research differences in quantity and dollar amount of inventory received versus invoiced. I sort it several different times to weed out and determine which ones to research and in what order. I decided to use the IF formula to indicate which differences were overages and which were shortages, in the manner that I indicated above. The formula can be used for all sorts of analysis and it can return values, text, or anything that you tell it to. There is an enormous amount of formulas in Excel to help with data analysis. I like that there is a wizard to help guide you through using them because you can’t possibly remember all of them to type out manually.

"Is this question part of your assignment? We can help"

ORDER NOW