If I don't have anything in the referenced cell noted in the formula
below it returns n/a. How do I get it to return something else? Example
(nothing)
(VLOOKUP(Quote!C21,'Data Base'!:A1:Z5000,6,FALSE)

I need help writing a macro that will change letters to numbers and add
the numbers for a total.
Using the alphbet with special values for each letter.
Example:

Please, please, please could anyone help with a conditional rounding problem
I urgently need to solve.
A figure needs to be calculated to 3 decimal places with the fourth decimal
place rounded DOWN when it is 5 or less but rounded UP if it is 6 or greater.

I am using the same formula on several different worksheets. Some work and
some return #N/A as a result. Any suggestions? Here is my formula:
=IF(ISERROR(VLOOKUP((CONCATENATE($C42,"INSQUOTE-AUTO")),Pronto2!$1:$2500,8,FALSE)),"",VLOOKUP((CONCATENATE($C42,"INSQUOTE-AUTO")) ...

I'm new to these more complex formulas in Excel, so I thought I might
get some help here please.
I am looking to do the following:
I am looking to enter a number into cell C8. This number will be

How do I a make an IF statement change the color of the cell based on the
number inputted?  For example I want 0-5 to be clear, 5-10 to be yellow, 10+
to be red.  I want to also change the text properties to change the color of
the text.  Can either be done?

Brand new user, appreciate the help!
I have a contact data in a specific vertical index in a single column.
I wanted to set up an array forumla to automatically transpose the data
horizontally. Couldn't do it because obviously the array function can

I have about 40,000 lines in my spreadsheet. For a given column, say column
k, can a macro copy/paste special/values in 1000 row blocks ?
In other words. Starting a K4, copy k4:k1004,  paste special /  value over
the same range. Then copy k1005:k2000,  paste special /  value over ...

New to creating custom functions.  I'm trying to add workday, which is an
add-in, to a function I'm creating but "Application.Workday(a,b)" isn't
working.  Any suggestions?

This is probably an easy one - but I don't feel the sharpest right now...
I have a MIN-formula like this:
=MIN(E4;E5;E6;E7;E8;E9;E10;E11)
but I'd like it to go as many rows down depending on a cell A1 (=8 in this

When I use find in an excel spreadsheet I want the box to be highlighted each
time it finds a match.
Can this be done for all future finds, until changed back?

I would like to sum/average numbers in column A, only if for that row, the
value in column B is a certain value.
e.g. Average column A if value in column B is 1.  Then again, average of
column A if value in column B is 2 etc.

In Column B I have calender dates for the year Starting from  29/01/06
thru to 29/06/06
In Cell R117  I have a Value 1 ( which denotes Bank Holiday not worked)
In Cells  R119 to 126 I have a list of Bank Holiday Days i.e .

I'm still having difficulty with Conditionl Format....
I like to apply the following...
In Column G
If cell equals number between 1 to 29  Colour Yellow on same row from

Each day I take attendance for my group here at work.  Is there a way
to create a macro that would emulate me hitting "File, Send To, Mail
Recipient, and enter the word "Attendance" (my distribution list) in
the TO: column.