Functions

lookup to multiple rows and columns
I have an spreadsheet with columns like: col A col D col E colF B230 8 1 0 F001 -5 0 10 F002 3 20 0 F010 5 -29 3 F014 40 ... 15 Feb 2010 12:05

Lookup function
I have excel 2003. I did a vlookup for my transcripts page. In the first vlookup i needed it to look for the letter grade and give me the gradepoint average. Now in the other cell i need it to look for the grade. In the cell that gives the gradepoint average it has a formula in their already. Can i still d... 14 Feb 2010 19:40

Conditional Formatting for one cell matching another with text
I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7 OR H7 MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED ... 14 Feb 2010 18:32

Formulas
How do I create a formula for this? Multiply the base value in cell B6 times 100% plus the value in cell C4. Place the second expression in parentheses so that addition is performed first and make the reference to the value in C4 absolute so that this formula can be copied down column c. ... 14 Feb 2010 16:18

Write a Formula
How do I write a formula for penalty on past due accounts with great than or equal to 1000 but less than 5000, apply a penalty of $100. For accounts with a past due balance of 5000 or more, apply a penalty of 200. For accounts with a ttl past due balance of less than 1000, no penalty? ... 13 Feb 2010 18:19

Duplicate value address search - apologies for cross post
Hi everyone, 21:00 on a Saturday night and I'm struggling with this! I have textual data in cells C158:L177 Unfortunately these are not all unique values ... I want to get the address of each dearched instance. In cell C179 I want to enter a search text which exists in the data. In D179 I want the ad... 13 Feb 2010 16:05

Sum Data if Column B = Q
I wish to sum all data in Sheet2 Column J, if the value in Sheet2 Column B = The value in Sheet1 Column A I've tried =SUMPRODUCT(PC_Month_Locations=A8,PC_Month) Named Ranges above used instead of absolute references ... 13 Feb 2010 11:33

LOOKUP VALUE OCCURS >ONCE IN TABLE ARRAY - RETURN LAST OCCURRE
Rob, Please post the answer instead of posting cryptic messages. This will help other users. Cheers ... 13 Feb 2010 03:54

Rolling average
Gentlemen, I have been assigned a new task, to make a score card for Key Performance Indicators. I have asked the concerned departments for the data. Now what is this term rolling average/ My data is as follows Data : safety valve caliberation Month jan feb march apr Planned 1... 13 Feb 2010 02:49

Tab Control
I have a 15 page pricing program I wrote in Excel 2007 which includes various forms which would be filled out by the operator. I want to be able to have the enter key or tab key move from one cell that needs data directly to a different cell which needs data. (Ex: A5 enter a client name - Enter/Tab to D3 ent... 12 Feb 2010 18:00