Hi
i know to do vlookup, but the problem here is, when i do vlookup function
and if the value is found then the result should be shown as "YES" if not
then "NO"

Any help with the attached would be much appreciated.
I have a spreadsheet with the months of the year listed in a row
starting in cell C1. However, every month has three columns, “2008”,
“2007” and “Variance”. In addition, I have a drop down box in cell A1

I have a spreadsheet with countries in one column.  I am trying to count the
number of times Armenia and Azerbaijan appear in this one column as a total.  
I am using this function =COUNTIFS('[Member
List(1).xls]Sheet1'!$C$2:$C$1108,"azerbaijan",'[Member

Hi there i have tried
= LEFT(A1,3) & "  " & RIGHT(A1,3
and it does not work.
I have excel 2008 mac.

I'm trying to add cells WITH numbers but they have letters
(alphanumerical).
Example:  A        B       C       D       E           Total of sick days
(S)  Total vacations (L)

I have first and last names in a list and need to have excel pull only the
first name. These names are all in the same column. I tried using LEFT but
can't figure out how to have excel stop once it hits the space between the
first and last name.

situation...
ColA                    ColD
Norton AV            78
Norton Suite         12

Suppose I have money of IDR 300,000,- ( this is my money not a loan). Now I
want to evaluate whether to Invest to build houses for rental. I have a
problem if to calculate the IRR for investment. I tried to make in first line
300,000, because this is my money, and then in the 2nd ...

I have been using Vlookup functions for several years in excel 2003 and love
them.  They are one of my favorite functions and I use the all the time.  My
office recently upgraded to Office 2007 and I noticed that the Vlookup
function is now case sensitive when it was not in Excel ...

I want to create a macro that copies and transposes data, returns to the next
row of data and repeat the process until the end.  I'm ok with the copy and
transpose bit, just the last bit.
Thanks

I have a question as to whether there is a fast and easy way to enter
some digits into a cell that already has digits. For example,  I have
a cell with the numbers 123456 and I would like to add 149 to the
beginning without having to manually go into the cell and add 149 to

I would like to format a column so that if no data has been entered in a cell
in that column then the cell would be colored or marked somehow. Is this
possible? I have tried Conditional Formatting but it only colors the cell if
there is data in that cell... I want to do the ...

Help please - I am a novice when it comes to spreadsheet-functions!
In a spreadsheet I try to add hours exceeding 24 hrs.  What I need is the
formula to put in the resulting cell, in order to get the result in hours and
minutes (not in hundreds) Ex:

I need to create a list in a new spreadsheet of unique values by pulling the
data from another spreadsheet in Excel 2007.
The value I want to check against is a 6-digit number (SKU) in a column on
the existing spreadsheet. Most of the SKUs are unique. However, many of the

--(MONTH(Cancellation!B16:B1013)=1)
Using the above with the SUMPRODUCT function would show results from January.
Now, I have a drop-down list that shows the months as text in Cell A1.
How can i adjust the above to use =A1 instead of =1?