Excel Basics #23: VLOOKUP function formula

Please can anyone help me answer any of these questions:

How would you add the contents of the cells from A1 to A10. Give 2 ways
to do this. (hint: Look up "Examples of common formulas" in Excel
help



How do you format a cell to have dollar signs next to the numbers?



How do you add the contents of cells A1 through A10 on sheet 1 and make
the answer show up on sheet 2?



How do you rename a sheet?



Can I delete the sheets that I don't need? If so how?



How do I freeze rows or columns of the sheet so that they don't'
move when you scroll up or down? Example: My name is in Column A, when
I scroll right my mane stays on the screen and column B moves behind A



How do you add up all the contents of column D and make the answer show
up in column C?


Thanks in advance!
abi

I have a spreadsheet that shows a date, because of shipping I need to enter a
date and then calculate three months back and enter that date, For example
Cell A1 March, 2004 and I have to enter into cell B1 January 2004, how do I
get Excel to do this automatically.

I went to the website cpearson.com and got the information for the syntax and the formula to sum numbers in different colors on a worksheet
now my problem is where do i put the visual basic part of the works so the formula can call on it
can you tell i have no idea but great hopes!!!
thanks everyone

Basicly the same as the title.. I want to learn more about excel... I consider myself to be just a bit better then a noob, i can use the sum function, and i think i understand how most easy things work

Alright i'm using Excel 2007, i created a table with 2 columns and 5 rows
cell A1 - A5 has a list of numbers, and Cells B1 - B5 has a list of food items,

I've created a blank User-Interface form, using VisualBasics which came inside excel 2007, how do i get the table in my Excel Sheet, to show as it is with it's color coding and grid lines in the VisualBasics Form,


My second question is, I also created a Seperate Visual Basics form in Visual Basics 2008, could i get the table in the Excel form, to show in the form in Visual Basics 2008 programme, I have no clue how to link Visual basics, to Excel so a non-overly technical step-by-step guide would be extremely appreciated,


Thank you,

I'm trying to populate a Word 2003 document with data from an Excel 2003 document -- I realize some use mail merge but this, for me, has been an excruciating pain in the neck, so I am trying to avoid it by going the Word bookmark route, which looks like it will fit the bill... if only I could figure it out!

I have done some searches on here and this is the code that seems to have set the precedent:

http://www.mrexcel.com/forum/showthread.php?t=478182

However, as a beginner, it's a bit overwhelming for me. While I'm learning a lot by looking at it and looking up the things I don't understand, it's taking a long time and I actually need to use something similar for my own project.

Specifically, I wanted to open a template letter; populate it from the active Excel row I'm working on; and then "Save As" so I can keep the template.

Is there some more generalized information out there that outlines this procedure? Otherwise, would someone be kind enough to separate the code and/or elaborate more on what the invididual lines/sections do?

Hope you can help!

I am using the following statement to avoid errors if there is a blank cell in a vlookup
=IFERROR(VLOOKUP($A19,Summary!$1:$1048576,15,FALSE)&"","").
This eliminates the N/A and 0 Jan 00 errors I was having before, which weren't consistantly trapped by a IFERROR(VLOOKUP...) statement, but the formula is returning a number rather than a date. Any idea how to fix it? I have tried reformatting the cell receiving the information. What is the function of the & in the formula?

can you use both MAS and VLOOKUP in the same formula ?

I'm have a master list of customer numbers that I would like to get the MAX date and it's corresponding value (from the "data" below). Please note that some there could be multiple customer numbers (that's why I would like to use MAX).

Cust Calendar Date Value
100979 5/7/2007 $0.
100984 11/8/2007 $0.
100984 12/5/2007 $10,422.67
100987 10/15/2007 $0.
100987 11/6/2007 $757.09
100987 11/26/2007 $3,586.5
100987 12/3/2007 $1,644.66
101076 6/12/2007 $0.
101383 10/30/2006 $0.
101385 9/6/2006 $0.
101671 10/25/2007 $0.
101671 11/30/2007 $56,510.72


Thanks in advance for your assistance !

Hye,
I am using Excel 2007 and I am trying to design a Log for Outgoing and Incoming letters/e-mails.
I am attaching herewith a sample file for your review.
I am facing following major issues:
1) Actually I want to make a Vlookup formula for almost 10-13 sheets. For the time being I am sending you tow samples files for two projects Gravity Tower and Bank, Workbook 1 (Both projects in one sheet) and Workbook 2 (Both projects are in separate sheets).

Workbook 2 has one problem that when I select Banks in the Project Ref. No. cell, it displays me Subcontractors/Companies Names for Bank project, whereas if I select 10, it does note display me list of Subcontractors/Companies Names under cell G5. Can you please help me? The reason may be that I am using VLookUP formula for one sheet only that is Banks as I did not know VLookUP formula for more than 2 sheets.

On the contrary in the Workbook 1, I can select both projects and it will display subcontractors/companies names for both but for this one I have to insert all information for both projects in the same sheet (Subcontractors). I have one issue here as well. I have one company name repeating for both Projects that is OBD. For both projects, Subcontractors/Companies Names cell displays OBD but under the Filed In it will display same files for OBD for both projects i.e., Filed in Gravity Tower - OBD File No. 01/ Filed in Gravity Tower - Interim Payments File No. 02 whereas for Bank project A I have separate file that is Filed in Bank File No. 01. If I make OBD to OBD10 for Gravity Tower then it will display me files for OBD for both projects Gravity Tower and Banks as both projects have different OBD names i.e. OBD10 (Gravity Tower) and OBD (Banks). Can you please tell me is there any way to use the same name OBD for both projects and it will display me their respective files as well?

2) I have pre-defined subcontractors/companies names for both projects. However, user can type new subcontractor/companies name under cell G5 (Workbooks 1 and 2) as I have given them permission. But the problem is that when they type new subcontractor/company name say for Gravity Tower, I want cell I5 (Filed In) to display all available files (as described in Subcontractors Sheet C3:C23 Workbooks 1 and 2) for the Gravity Tower so that user can check in which file this letter should be filed in.

Furthermore, under the Type cell, if user selects Letters/E-mails/Internal Memos, it should display all Gravity Tower and Banks in the cell D5 and other related information as well in other cells like E5…I5, J5. But if user selects Company Profiles/Invitation Letters, it should display cell D5 and other cells empty.
Can anybody help me?
Thanks.
Mubasher

My vlookup formula has a range reference in another worksheet i.e '1c' in the below formula...can you help me incorporate the indirect formula..i tried but i cant get it to work..thanks

2) =if(iserror(vlookup($b3,'1c'!$AQ$2:$BI$700,2,false)),"",(vlookup($b3,'1c'!$AQ$2:$BI$700,2,false)))