I have a list of IDs that I'm performing a vlookup on.  But in order to save
space I don't want to list out all of the results of the vlookup.  So I did a
single-cell array for the vlookup on the IDs.  
{=VLOOKUP(N9:Q9,ModelData!$A:$BZ,63,FALSE)}

Hi I have 2 columns of symbols with 8 variations as follows
Col 1                               Col 2
=                                    <
=                                     =

I have looked through the Excel posts but could not find an answerto the
following question. I would be grateful for any help.
I would like a formula that will display the average of columns A:C in
column D. This works fine if there are values in columns A:C, eg

I am using a fairly simple formula.  I am subtracting one cell from another
and dividing by a third do an example would look like this (I2-V4)/V3.  I
want to paste the entire column with this so that the next formula would be
(I3-V4)/V3, however it appears as (I3-V5)/V4).  How do ...

I would like to find a function that will take the date in one column and
tell me what date is 4 months after that date - any thoughts

So, this is a complicated one: I would like to create a formula that
cross-matches between one sheet, which has the entire dataset (one row/
record for each student (unique ID number), and the values for each field) on
it, and another, which has the list of errors, independently ...

I am working on a Bonus/Abscence/Timesheet workbook for our office.  I have
most everything worked out, but I have a few glitches if someone would/could
help me please.
1.  On the timesheet, I need the G column to calculate the times, but my

i have 10 columns of data all coresponding by row.  I want to sort these
columns all together so that the corresponding data stays together.  However,
i do not want to have to manually click sort every time my data updates. can
anyone help i really need help im a co-op student ...

Does anyone have any suggestions on how to solve the problem of having too
long coding for Macro? I don't want to split the coding into 2 macro
separately.
Does anyone have any suggestions?

I'm trying to count the number of occurances of a value between two dates
that I specify.
I've done this by using the following formula and it works:
=COUNTIF('Pre-Sales & WIP'!E:E,">="&Analysis!C1)-COUNTIF('Pre-Sales &

Had a look in previous threads to no avail
I have post codes in cells across page
A1 CV
B1 35

Dear Sir,
Thank you for the feature of speed filling cells downwards in a table by
clicking the bottom right corner of the cell.
This feature has enable the user to work more swiftly with the worksheets.

When countif does not find any occurrences, it writes "0". Is there anyway
to change that so that it writes nothing - leaves a blank)?

I am looking to set up a macro to unhide a new row every time a button is
clicked.
I have set up a macro that opens up a new row, but it doesn't add any rows
after that.

I have a two variable look up problem.
In Cell A1 I have a state to enter.  In cell A2, I have a loan amount. I
need cell A3 to give me the closing costs based on the two values above. My
table looks similar to this: