I have a table of five digit SKU numbers that I need to cross-reference with
a list of UPC numbers and sales data.
The last five digits of the UPC number are the SKU number.
So my VLOOKUP is basically

I used to use ETrade's DDE (Dynamic Data Exchange) addin with Excel 2003 on
Windows XP, but now that I have upgraded to Vista, the ETrade add-in menu no
longer loads up, even though I can see the add-in in Tools-Addins.

Hi. Can someone help with this forumla please? I've trawled the
Internet but not yet found the answer so this is my last hope.
I have a spreadsheet with the following information:
     A                 B             C         D        More grades

Why is the selection for inserting rows and columns under insert cells grayed
out?

I have an old file that is set up in three columns like so:
A    C    E
B    D    F
I need the data in six columns:  A  B  C  D  E  F  in order to sort, etc.

Hi, I have a workbook with vLookups to 4 other files which work ok.  The
problem arises when I want to run formatting macros.  It runs but then
produces the "Update File" explorer box and is looking for a  file name which
does not exist.

MS Office 2003-Excel - when I print a sheet that has borders around the
cells, as you move down the printed page, the bottom cell borders print above
the data in the cell so it looks like the data has a strike-thru instead of
the cell border.  The top half of the printed page ...

I have an excel workbook with multiple work sheets (Summary, January,
february..., December)  On the Summary worksheet I want to create a 3d
reference summing all B9 cells across the monthly worksheets.  I can do this
for a specified range of months, like =sum(january:December!B9 ...

I'm not sure how to describe this. I have a row of information and
some of the cells need to change daily. I'd like to keep a record of
the info for the past couple of weeks. Right now I'm doing the tedious
work of cutting and pasting the info in each cell before I change it.

I am trying to set up a drop down list (list is set up ok) that has the
months of the year in it to correspond with a number for the month using IF,
but it doesn't seem to work.  Here is the formula I was trying in cell A2:
IF(A1="January",(1))*IF(A1="February",(2))...etc.

I am new to the 2007 version and cannot figure out why MARGINS, ORIENTATION,
and SIZE are grayed out under the Page Layout tab.  I have tried copying and
pasting to new workbook but still not working.  Any suggestions?

I get an error whenever I try to open an excel file attached to an email or
from the folder (if I open my computer or my documents).  In both cases is
says the that file cannot be found.  I do not have a problem opening an excel
file if I open the excel program first.

This is what i need to do. i need a running clock that shows days, hours and
min from 12-27-2007.  im very new to this, so if you can help, please spell
it out very well

I am trying to add a cell from one worksheet to a formula in another
worksheet but it just shows the forumula in the total box instead of the
figure what am I doing wrong?

Hello  
I have  conditional formatting =$$AA5="Red"  format is highlight in red,
second conditional format is =$$AA5="Blue" format is highlight in blue.
I want  to total all the cells  in column D,that are highlighted in red  and