General

Look up, return value
i have a list of job codes in Sheet 1 column V that need to be updated with new codes listed in Sheet 2 column B. Sheet 2 column A contains the old job code, column b the new one. How do I reference on Sheet 1 look at column v, find the matching job code in Sheet 2 column A and return the value in Sheet 2... 31 Mar 2010 14:22

Help with Text and Dates
I'm hoping someone on here can assist me....Both of these formulas are returning #Name errors.......Please suggest alternative formulas.... Formula #1: "ALL QUOTED LEASE FACTORS EXPIRE ON "&TEXT(EOMONTH(NOW(),0),"MMM-DD-YYYY")&" AND ARE SUBJECT TO VERIFICATION PRIOR TO FUNDING" Formula #2: "QUOTED ASSUMPT... 31 Mar 2010 09:52

Find and Replace only the first character
I am trying to replace only the first number in a date. example: 6/6/10 with 7/6/10 I am doing a find 6/ and a replace 7/ but it changes the 7/6 to 7/7 and I only want to look at the first number in the date. Can anyone help me???? ... 31 Mar 2010 11:00

IF Statement troubles
I have a list box in F5 with 24, 18,14, 12,10. I need F7 to return if: 24=2400 18=1350 14=816 12=600 10=416 The first part of the below formula works, but I can't get it to work past that. Could someone please help? =IF(F5=(24),2400,If(or(f5=(18),1350))) Thank you! ... 31 Mar 2010 09:52

Print Button
On my summary tab, I want to add a print button command that will print the entire work book if the button is pushed. How do I add the print button? ... 31 Mar 2010 09:52

How do I import a file in DTF format into Excel 2007?
In Excel 2000, we were able to import *.DTF files that were created from a program on an IBM i Series Computer. Since upgrading to office 2007, we can't find how to import these files ... 31 Mar 2010 11:00

Please very urgent and help
I have an excel with the following column company Customer currency amount 1 AA ST 12 1 BB ST 2.50 1 BB EU 3.50 2 CC ST 12.00 2 ... 31 Mar 2010 11:00

Conditional Formating based on start and end dates
Hello, I am trying to create a spreadsheet to track the progress of tasks in a project. I found a good example on the web in Open Office and would like to model my spreadsheet off of that example. However, I am new to Excel and can't get past the conditional formating issues. Basically my spreadsheet is ... 31 Mar 2010 08:45

Can I add to a cell value without manual calculation?
I have a value in a cell eg 100 and want to add another value to it eg 10. Can this be done by entering the additional value and the sum completed automatically? ... 31 Mar 2010 08:45

Remove duplicates from Sheet 2
Hi everyone, I have 2 sheets containing data Sheet 1 A1-AT623 and Sheet 2 A1-AF822. Where I already have data in Sheet 1 I would like to be able to delete (or extract to a 3rd sheet) that row in Sheet 2. If anyone could help that would be fantastic! Cheers Diddy ... 1 Apr 2010 11:16