Functions

LookUP function with multiple variables and worksheets
I am trying to create a formula for the following: If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col C on worksheet 2 then the value of cell X equals the value of cell Y. I need 2 sets of data to match exactly in order to use the value found in a third location. Is this possibl... 18 Mar 2010 14:22

Conditional Formatting for a dashboard with a drop down menu
I am formating a dashboard where you select which dash board from a drop down menu (P&L, KPI's etc.). When I change the dash board with the drop down menu the conditional formatting no longer works. If I edit the conditional format rules and select apply it works again. What do I need to do to automatically ... 18 Mar 2010 13:01

Count with two criteria
I am working in Excel 2003, I am trying to count with two criteria and multiple sheets. I am using this formula: =SUMPRODUCT(('Sum 1Q10'!A2:A4="BKD")*('Sum 1Q10'!F2:F4="Open")) my result is 0. It should be 1. Is there another way to do this? I really need help. ... 18 Mar 2010 13:01

Sumproduct but only first time corresponding value is seen e.g. un
Using XL03 Sample Data: Name Race Speed Avg Speed Track Month Joe 2:12 2:15 OFCF Jan Joe 2:28 2:15 ADL Feb Mary 2:14 2:07 ADL Jan Joe 2:15 2:15 ADL Feb etc ... 18 Mar 2010 14:22

Conditional Format for Blank Cells
I am trying to figure out, if possible, to make certain blank cells in a row/column to be filled-in (blacked out) if a certain cell contains a particular text. For example: Let's say I'm wanting to create a spreadsheet that will help me indicated, from a list of ingredients in Column A, what ingredients to mak... 18 Mar 2010 18:59

VLOOKUP with HLOOKUP
Hi, I thought this was simple and i could google it. but could not find a solution. Age 3 ( premium per years) 5 ( premium per year) etc etc 1 5000 7000 9000 2 3 4 etc in years A cell ... 19 Mar 2010 00:35

retrieving current data
i want to pull data from another workbook into a workbook. what formula can i use that will pull only data from the current month that has data in it? ... 18 Mar 2010 16:39

salary defined by slab table
Hi, I have a sheet with a table which has number of hours in a column A. Salary per hour is in column B as under. 50 3.5 100 5.7 150 7.7 300 8.8 This is not just simple multiplication function. If you notice, first 3 rows in A total up to 300 hours and 4th row has 300. It mea... 20 Mar 2010 23:17

How to enable auto height with merged cells?
I previously asked a question regarding auto height with merged cells and was given a code to enter into visual basic. I entered the code and copied & pasted a narrative into the row. It originally seemed to work. But after closing the workbook and re-opening it another day the 'referenced' row is back to the o... 18 Mar 2010 11:43

Microsoft 2007
What is the formula for a percent change between 2 cells? Everything I am trying will not work with the 2007 version. I have used the formula I know in an older version and it worked fine. Please help ... 18 Mar 2010 13:01