Trying to create a formula that will do the following: If a1="1", then vlookup ...........or if A1="2" then vlookup......

Hi, i have a table like this: john 4500 john 1200 mary 900 jim 5000 john 3700 mary 2300 jim 1400

I am creating a questionnaire, where there are yes and no questions that have radio buttons next to each answer. I have two questions. 1. Currently I have...

I am getting this message box more frequently in my Excel workbook. Cannot find in help topics. Thanks

My spreadsheet only appears in the top left of the page and I am unable to resize it. You can only view rows 1-17. You can scrool down and across. This is...

Hello, I have created a Pivot Table in a Excel 2007 Template which uses the data from an Access 2007 table. In my Connection Properties I have all the...

I need to put a sub command into the object section for a formula to work. However i am not understanding what or where the object or object section is. Does...

Dear, I have data in the range of cells A2:E1000. The row 1 has the headers to which i had given filters. The column E has a numeric value for which an...

Hello, Does anyone know why the "$" command will not work in formulas when running VISTA? Does anyone have a solution? A simple version of my problem...

How do you correct this ?

nI am in dire need of a payroll sheet suggestion for employees under a 2 week pay period. It must have a lunch hour also. Any suggestions will be so much...

I have an excel sheet in wich I paste everyday new information, replacing the previous day information. There's a clipart that has been pasted over and over,...

Can you please help me with setting up a formula? Product A = $100 Product A = $100 Product A = $300 I want my result to be Product A = $500 not $100....

I want to enter a value as .050 x 27.5 in a cell. I can due this by formatting the cell as text, but when I copy to a new cell I get 0.050 x 27.5. Formatting...

I imported a tab-delimited text file, with quotation marks as the text qualifiers. Excel removed the marks, and now I need to save the file back as text,...

Hello: The client has a dual monitor. And, we have a 3rd-party Excel Add-In that "pushes" data into our accounting system from this excel spreadsheet with a...

I'm using an XLS spreadsheet in Excel 2007, and I can't save it in either the old or new format. the message says "Drawing Objects in one or more sheet(s) in...

Hi I have a file with a udf extension. When I searched the several sites said that it was related to excel, so I opened it with excel. When opened, it is...

I have searched this forum and Excel help and cannot find the answer to my seemingly simple question. How does a user take a file out of exclusive use? We...

How can I create a calculation from the total of a count of a field on a pivot table? Example: I need to calculate the number of employees for each process...