Hi. I use VLOOKUP formula's every single day - I use them A LOT !
My current machine has Ms Excel 2003.
A normal Vlookup formula looks like :
=VLOOKUP(A2,Sheet1!$A$16:$B$21,16,FALSE)

I'm trying to perform a count based on two columns and two conditions. I've
searched the forum and found several options but can't get any of them to
work. Will "countif" not work with date?
Here's what I'm doing:

I wanted to know if there was a macro that would replace all formulas in a
worksheet with their respective value only.
Thanks.

Is it possible to take a single column (12,000+ rows)of data and break it
into several columns to be able to print on 8.5x11 paper?
Example:
This:                                       Converted to this across the page:

When I use the "find" feature to search for a word on a large worksheet,
Excel 2000 brings me to the cell containing the word.  Sometimes my cells
have a LOT of words in them.  It would be very helpful, if Excel would also
highlight the word in the cell to make locating it easier ...

Can I set a cell to equal 1 for a font colored "RED" in another cell , such as:
if  cell  B1 is  "RED" font colored i need cell C1 to be =1
Thanks

Is there a way to automatically update a cell in Excel 2000 with the date
that the file was last saved?
Thanks!

i have an excel spreadsheet at work that i have to email to other employees
as it is updated. i recently had to have windows xp reloaded , until this
time i could click on the email icon on the excel toolbar and it would ask me
if i wanted to send the complete workbook , i would ...

How can I find a part of a text string in a cell from an external file?
This is what I currently have but it wont let me use wildcards (e.g.
"*ages*").
{=COUNT(IF('C:\[fileA.xls]sheetA'!$M$4:$M$1000="ages",'C:\[fileA.xls]sheetA'!$L$4:$L$1000))}

I can't get a formula in excel to recalculate when copied and pasted to
another cell. Help!
I'm trying to get three of the same bits of data from 300 different
worksheets in an excel file. Each worksheet is named with a person's

I want to use a short cut to move about a large spreadsheet to non-named
cells.  Like D5065 or AA1256.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I want to generate a new number sequentially everytime I open my excell
document.

just ran into a problem after looking at the average of a pivot table and
finding the result not logical. Is it possible to do a weighted average
calculation in a pivot table? It currently takes the average of all the
averages and it obviously doesn't make any sense.

I have an Excel spreadsheet with Last names in Column A and First names in
Column B. I am trying to combine the two columns into one (last name, first
name). The spreadsheet contains 4,184 rows, is there a way to convert the
entire spreadsheet? Thank you in advance for your help.

We have Office 2003 with a spreadsheet with 3 columns.  A is written text, b
and c currently are general formatting with numbers.  When the A1:C20 area
(all cells) and select conditional formatting and say value is greater than
20000 turn red and add a format and say anything ...