I have a spreadsheet setup and in one cell there are address details but in
between the address details there is a square symbol.
In some of the cells there are up to 6 different address lines with some
only have 1 or 2 address lines in there.

I'm trying to use a vLookup and running into trouble.  On the table
array that I'm looking in there are multiple instances of the lookup
value.  Does anyone have any recomendations for a quick/easy way to got
the totals of the multiple lookup values?

I need a simple formula to get the result says, 48,000 (pmt) in 4 years time
to 44,678 (present value)
See below example
        Pmt    5%    PV

AS THE SAME WAY THAT WE CHANGE THE WINDOWS IN THE EXPLORER WITH ALT+TAB HOW
CAN WE CHANGE BETWEEN THE MENU OF FIND AND THE SHEETS TO USE ONLY THE
KEYBOARD, THANKS A LOT

I have a formula that returns a lookup value
=VLOOKUP(A10,VarietyLookUpTable!$A$2:$C$56,2,FALSE)
but when I try to make it so that there is no value in the cell if the
reference cell is blank

Can anyone show me how to have a multiple page workbook always open to the
same worksheet. (Splash Page)
Thanks Kevin

I have run into the need to be able to count data over a large numbe
of worksheets that all have an identical format (so cell D4 has th
same type of data in it on every page).  I want to be able to count th
number of occurances that cell D4="Division" and N12>0.6  I currentl

I am trying to set up a spreadsheet that will flag me 21 days from the date I
send out documents. So that I can follow up on those documents.

How can I sum cells in range B2:F10 based on two criteria:
* A2:A10 = "XXX"
* B1:F1 = "YYY"
Thanks,

I WOULD LIKE TO CHANGE FROM ONE SHEET TO ANOTHER WITH A COMBINATION KEY  AND
NOT HAVE TO USE THE MOUSE EACH TIME THAT I HAVE DO IT.
THANKS A LOT

I have a data set (numbers) say B1 to B10. I have another data set
(numbers) E1 to E10. I want to compare a value in set E with Set B and
return 1 if there is a match. If not I want to return 0. I want to do
this for the entire set E.

I keep getting #VALUE! message. Why doesn't this formula work? What am I
missing? There is no text in any of the fields, only numbers. HELP!!
=B5-(D5:G5)

This is what I want to accomplish but I do not know how.  I am new at this.  
In cells D-I, I want to be able to click on the cell and bring up a dialogue
box that consists of a list of checkboxes, which I can check off as
completed, tasks if you will.  I would also like the ...

I would like a formula that will indicate if a row is blank or not.
this function in cell K2 {if A2:J2 is null, then put "Remove", else "Keep".}
so if that range is blank then put "Remove" if C2 has a value then put
"Keep" in K2 cell

I have a worksheet that contains legacy data that is being cleaned to
conform to specific formats and conventions.  I have another worksheet that
uses this cleaned data to build a new database row.  I want to put a drop
down list in my database row worksheet that lists only the ...