Threads Replies Last Post 1263 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   working with nested vlookup formulas =IF(ISNA(VLOOKUP($E8,Pension,9,FALSE)),"Defined",VLOOKUP($E8,Pension,9,FALSE)) This formula is works great in there is a number in the E collumn. but if there is no number in the E column it show "defined" I what it to show nothing. any ideas... 3 12/31/2008 5:29:13 AM Prada shoes (paypal payment)www.king-trade.cn ) Footwear (paypal payment)www.king-trade.cn ) Paul Smith shoes Jordan shoes Bape shoes Chanel shoes (paypal payment)www.king-trade.cn ) D&G shoes Dior shoes ED hardy shoes Evisu shoes Fendi shoes (paypal payment)www.king-trade.cn ) Gucci shoes ` Hogan shoes (paypal payment)www.king-trade.cn ) Lv shoes Prada shoes (paypal payment)www.king-trade.cn ) Timberland shoes Tous shoes Ug... 1 12/31/2008 5:18:58 AM NIKE AIR JORDAN FORCE FUSION SHOES AJF 5 V JORDANs 5 FUSION NIKE shoes on AIR Jordan 1 (paypal payment)www.king-trade.cn AIR Jordan 2 AIR Jordan 3 AIR Jordan 4 AIR Jordan 5 (paypal payment)www.king-trade.cn AIR Jordan 6 Rings AIR Jordan 6 AIR Jordan 7 AIR Jordan 8 AIR Jordan 9 (paypal payment)www.king-trade.cn AIR Jordan 10 AIR Jordan 11 AIR Jordan 12 AIR Jordan 13 (paypal payment)www.king-trade.cn AIR Jordan 14 AIR Jordan 15 AIR Jordan 16 AI... 1 12/31/2008 5:18:06 AM Using Vlookup with multiple sheet I am trying to update data on mutiply sheet into one spreadsheet This is a fornightly payroll workbook where each sheet is the date of the fornight payment. After I set up the vlookup formulae to pick up the first pay period in say colum c. Can I edit the formulae to pick up data in the next sheet, without actually typing in the sheet name or using find and replace. Staff 4-Jan-08 1... 4 12/31/2008 4:02:18 AM How do I input these formulas into cells that I want written in? If an employee input a dollar amount into G12, can I mandate he fill in what the purpose was in A12? If he doesn't fill in the annotation in A12, then he has to remove the dollar amount in G12 before proceeding with the rest of the form. The highest dollar amount used in G12 would be $75. Want dollar amount in G12 Want text in A12 I can make it work outside my cells with Cell I for... 5 12/31/2008 3:44:00 AM Calculated item - problem Hey, I have a problem with my calculated item in my Pivot Table. The Pivot Table is as follows 2007 2008 Country 1 Area A 43 50 Area B 60 70 Country 2 Area X 76 89 Area Y ... 3 12/31/2008 3:16:47 AM formula to find a range of cells = to a value I need to do calculations on multiple cells that are in multiple rows. The rows that I need to work with will all have the same value in the first column. The spreadsheet is already sorted by the first column, I just need to know how many rows have the same value in the first column. Then I will write a formula that will use that range for doing some basic math calculations. Thank ... 5 12/31/2008 1:46:01 AM Eliminating blank cells How do I eliminate the blank cells in my worksheet so that everything essentially shifts to the left until the empty cells are gone? I want this: To look like this: A _ 5 1 _ 3 1 _ A 5 1 3 1 B 9 _ _ 1 2 1 9 B 9 1 2 1 9 C 3 1 2 _ _ 2 8 C 3 1 2 2 8 D _ _ 6 1 3 _ 2 D 6 1 3 2 * The _ repre... 11 12/30/2008 11:41:01 PM Label colomn with the headers I have big like following Cables and Cords R9858 Round Gray Cable HH942 Optical Drive Serial ATA NJ889 Thermal Sensor Cable MK154 Cable Assembly for Ribbon X9259 Ribbon Cable for DIAG FH439 Cable Assembly for Flex-Bay 5120P Power Cord, 6FT, 5R598 Power Cord, 6FT, MK524 Hard Drive Serial there is a big file with different headings I need to delete the heading(cables and c... 4 12/30/2008 10:30:16 PM How can I freeze rows in the middle of a worksheet? (Line 14-15) ... 5 12/30/2008 10:19:18 PM How do I add a worksheet to an existing EXCEL file? I have 3 worksheets in an existing EXCEL file. I need to add additional worksheets. How do I do this? Please advise. Thank you!... 4 12/30/2008 10:12:37 PM How do I unlock some menu items? I use Microsoft Office Student and Teacher Edition 2003 on my computer at home. While I was out of the room, one of the kittens walked across the keyboard and locked the 'undo' and 'redo' arrows. They are 'grayed' out and only turn black when I tried to reinstall them, which didn't work. Does anyone know how to 'undo' their help? -- Betty Boop... 7 12/30/2008 9:48:57 PM What's themost efficient way I have sales people 1 through 5. If one of them sells something and enters it I want to be determine which person did the biz; kinda like "if number under Prod then the person in the left cell did the biz". I'm trying to be most efficient since I have a table of 7 x 7. Prod SPerson1 SPerson2 SPerson3 $100 SPerson4 SPerson5 Once I know who did the biz, sa... 3 12/30/2008 9:31:37 PM Insert a date that does not update if a condition is true Hey and thanks in advance I need to insert the current date and time into a cell (that will not update again) IF another cell is not empty: IF(C3>0,NOW()," ") However, this formula allows the date and time to update each time the workbook functions update. I need the date to be fixed. Thx! -- FirstVette52... 10 12/30/2008 9:25:53 PM Sumproduct using Tables I have the following formula that works just fine, except that I need help with the formula when G33 is blank. I would like the formula cell (H33) to remain blank if no value has been entered. Any suggestions? =CHOOSE(SUMPRODUCT(--($A$1:$A$17=E53),--(G53>=$B$1:$B$17),$D$1:$D$17)+SUMPRODUCT(--(E53>=$A$19:$A$23),--(G53>$B$19:$B$23),--(G53<=$C$19:$C$23),$D$19:$D$23)+SUMPRODUCT(--... 9 12/30/2008 9:23:34 PM Filter One Sheet into Many I would like to create many sheets out of one... I have a dataset which has a group column, I want to be able to create a sheet for each group in this column and only have those records displayed on the new sheet and name the sheet by the group... Is there a way of doing this? Regards - Paul ... 5 12/30/2008 8:55:41 PM linking workbooks when source data moves I need to be able to link two workbooks so that the source data updates the destination workbook. The second issue is that my source data moves, as information is added and removed, as well as sorted. Can this be done? ... 2 12/30/2008 8:47:08 PM Insert file and tab name from list into formula File1 has multiple tabs labeled as Eastside, Westside, Southside, Northside, etc. File2 has the same tabs with data covering a different time period In File3, column A will list a file name and column B will list a tab name. I want to create a formula that will go to a specified cell in one of those file / tab combinations, based upon the variables listed in columns A & B. I also w... 4 12/30/2008 8:36:40 PM Compatibility Problem between Excel 2003 and 2007 Excel 2007 imcorporated some functions which used to be in a add in previous versions. This is the case, for example, for the workday() and networkdays() functions but there are some others. When I open a 2003 spreadsheet with this functions Excel prompts I'm using "reserved" names for user defined function which is now internal. The problem is when I save this 2003 spreadsheet in Exce... 3 12/30/2008 8:22:07 PM How do you add or remove gridlines from an individual cell? Someone has changed a worksheet I created so that not all of the gridlines appear. I can use the format painter to copy the gridlines from rows that are ok to the ones that aren't but can't figure out how this person removed the gridlines from individual cells. They are not borders, they are actual gridlines.... 4 12/30/2008 7:29:07 PM is there a template to create a sales tax chart? ... 2 12/30/2008 6:59:07 PM vlookup in one table if no data look in another I have a rather large workbook with dozens of pages and I'm having trouble with a vlookup that I would appreciate help with. What I need is for one table (with 2009 data) to be looked at and if there's no value then to look at another table (with 2008 data). The formula I came up with, that doesn't work if there's no 2009 data, is: =IF(VLOOKUP($B$94,ALG09Data,4,FALSE),VLOOKUP($B$94,ALG08Dat... 5 12/30/2008 6:26:37 PM Help in ranking Formula Hi All, I have data in two rows I need to give ranking rule, based on quality first and then who is highest in production. Production Quality 9300 100.00% 9310 99.99% 9320 99.98% 9330 99.97% 9340 99.96% 9350 99.95% 9360 100.00% 9370 99.99% 9380 99.98% 9390 99.97% 9400 99.96% 9410 99.95% 9420 100.00% 9430 99.99% For Instance- If I choose Quality for Ranking, I wil get thre... 10 12/30/2008 5:56:27 PM Vlookup Function with Multiple Reference Columns I posted a question a few days ago, but didn't get an answer so let me give more detail. I am trying to do a Vlookup in B1 in Worksheet 2 that references a table in worksheet 1. The reference value though can be found in either column A, B or C and the results (output) will be three columns away from the reference column of the table. The Vlookup function looks at the most left column... 5 12/30/2008 5:42:56 PM Create Calculation to return number of weeks and days I need to create a formula where it calculates the number of weeks and days between 2 dates. For example: A2 = 12/25/08 B2 = 1/30/09 C2 = 5 weeks 1 day I found example formulas that calculates years, months and days....but no weeks. Any help is most appreciated! Thanks!... 9 12/30/2008 5:22:07 PM 1263 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>