Using Iserror with If statement and Vlookup I have the following formula in a cell: =IF(\$K2="STEEL",VLOOKUP(\$B2,'Macos 12 Mo. Data'!\$A\$4:\$AU\$326,40,FALSE),0) Problem is that the results of this are used for calculations and K2 sometimes doesn't equal "STEEL" so I get an error. I've tried putting an Iserror and have the error = 0 but am doing something w... 12 Mar 2010 10:33 Help with SUMIF & AND function Hi, how do I create a formula to sumarize value by group and subgroup? My formula by group works but unfortunately the 2nd one doesn't work. What I need is : sumarize the value (column D ) of all products having group = A and subgroup = A. total group subgroup value by_gr by_subgr A A 10 A A 20 A B 30... 12 Mar 2010 10:33 Excel file size increased 3 times after saving!!!! Hi all, I have a very strange situation with my Excel workbook. I created Excel workbook with conditional formulas (no other formulas) which total size is 3 Mb. After I put simple data for calculation and saved the workbook the size increased to 10Mb! The data itself is just about 70Kb. I use Excel 2002 at w... 13 Mar 2010 11:58 Consolidating Data Between Worksheets with Duplicates Removed I am interested in tracking lab values that my staff enter into a daily worksheet. I would like to compile monthly percentages (% low, % in range, % high) but sometimes it is necessary to have duplicate data on consecutive worksheets for my staff's workflow. These duplicate values will cause my percentages (a... 12 Mar 2010 20:43 Return Corresponding Value Based on Comparing Two Sheets of Data Can someone please help me find a formula (or two) for this example. If you can show me a couple of ways to do this (so I can learn), I'd greatly appreciate it! Thanks! I'm trying to figure out a formula (or two) that will help me auto-populate the ? fields within ColumnB of Sheet 2. Also, I want the ? value f... 12 Mar 2010 00:42 slope? Hi, if I have the following table how do I find x? 1 1134.9 2 3 1138.99 4 5 x ... 12 Mar 2010 00:42 Check to see if a value exists in a list? Hi and thanks again for your help out there... Is there any function to test if a particular value exists in a list? A simple example: Column A1= car; A2=train; A3=plane In B2 I place "car". Is there a function which will return TRUE if B2 exists in A1:A3, or false otherwise? Thanks Pradhan ... 14 Mar 2010 09:48 Why won't this function work? This function works: =IF(B71="","",IF(B71<=330,"Standard","Below Standard")) But when I change "330" to "R4" it doesn't work. R4 is a number field that has 330 in it. It doesn't seem to be recognizing the Value_if_False statement. Any number will make it show "Standard." =IF(B71="","",IF(B71<=R4,"Standard","Be... 12 Mar 2010 00:42 SUMIF or SUMIFS help I have 2 sheets in one workbook (Sheet 1 and Sheet 2) Sheet 2 has 3 columns: A B C MAKE TYPE QTY 1 toyota compact 10 2 ford pickup 15 3 toyota sedan 20 4 toyota pickup 80 5 nissan hybrid 10 Sheet 1 has 2 co... 11 Mar 2010 20:15 Countif function I need to find out how this countif works. In my excel class I did the countif like this. Statistical, countif, I selected the range, press F4, tab and with insertion point in the criteria box I clicked the cell that was needed. It came out really well. However, when I had to do the skills review, I did exactl... 11 Mar 2010 18:01