Hi there,
I am using VLOOKUP to calculate vehicle usage hours... or should I say, I am
TRYING to use.
It keeps sending back a #VALUE! error and I have absolutely no idea why. I

Hi,
I need help here.
Here is the scenario.
When I type alphabets in lower cases at each cell, I need the cell to

Is there a formula that will pull specific text from a range of columns in a
single row?
FOr example, I want to copy the words "Transportaion Form" into specific
cell assuming those words are located in Columns C:G of Row 3 .

I'm sure this has been discussed before but I'm a complete novice on
Excel so any help is appreciated.
I've created a Calendar Control and can call the macro up either by
clicking a button or right-clicking the mouse.  When I click on a date

=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
When using this to get the next month, find some problem when at end of a
long month (with 31 days), the result came back is the first day of 2 months
later. eg a1=31/3/2008 the result will be 1/5/2008 and not the expected

Can someone advise how can I protect the cell which contain formual and I
know excel had a function to uncolor the cell when result is being calculate.
Example
Formula in cell A3 with Blue Color ==> A1 + A2

The following function looks up a value in another workbook:
=OFFSET('PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$C$8,MATCH($A11,'PATH\Testing\2008hi\[0208hi.xls]WKSHT_NAME'!$A$9:$A$96,0)+4,0)
Unfortunately when that particular workbook is closed, the function returns
a #VALUE! ...

this is a stupid question i know, but please help. i have 2 columns
containing corresponding data, i.e. cell a6 contains the item i sell, cell b6
the price of that item.  i have 148 different items, with 148 corresponding
prices - in cells a6 through a154, corresponding with ...

I have two lists in separate spreadsheets, illustrated below.  How do I find
a match using the Amount1 field as the key, and match to the second list with
the correct batch number?  Both lists are unequal in the number of records.
Thanks for any help.

I would like a count for County A with type Lend, AB owned.
County  Type
A           Lend by exit
A           Lend by exit, estate, AB owned

I want to insert a total in column C for names in column A that have the
first several characters matching (I was thinking of using the LEFT
function), but I only want the total to appear when the aggregate amount for
a name is more than 100.

Need some help. Worksheets 1 & 2 in one spreadsheet.
Worksheet 2 has data like this...
1234, Mark, A, B, C, D
1235, Fred, D, C, A

Hello World,
In my spreadsheet I have a series of cascading drop down menus.  I
would like it if I could drop down cell A9 to select "1120e" and when
you do that cell A10 provides a link to another tab in the spreadsheet

Hi there excel gurus.  I'm stumped as to how to rectify a bug in Excel2000
with the COUNTIF function.  Simply put, the number is not coming up
correctly.  I have a very simple function:
=COUNTIF(Current!D1:D10000,">=180")

How can I format a cell to display the current quarter?