I have several sheets with tabels using VLOOKUP in adjecent collums.
eg.
=VLOOKUP($A3;'DATA'!$A$6:$DC$283;56) followed by
=VLOOKUP($A3;'DATA'!$A$6:$DC$283;59) etc.

I am using VLOOKUP for training participants, the problem which I am facing
now on my list I have got few participants with same surname and my VLOOKUP
picks the 1st participant from the list. Any chance that I can have two or
three cells with Vlookup formula and the cells ...

Here's my functional formula
=IF(OR(O13=1,O14=1,O15=1,O16=1,O17=1,O18=1),"Need to answer all
statements",IF(AND(O13=2,O14=2,O15=2,O16=2,O17=2,O18=2),2,IF(OR(O13=3,O14=3,O15=3),"3",IF(AND(O13=2,O14=2,O15=2,(SUM(O16:O18))=7),2,IF(AND(O13=2,O14=2,O15=2,(SUM(O16:O18))=8),"Btw
Red & ...

I am looking for a possible If Function that will read col E, and if it is
East/west or tower it will divide the adjucent cell in Col f (15) by what I
want east/west and tower to represent. I have given this below. I do not want
to type in the 2,1.86 and 2. ideally just represent ...

I have tried everything to format the cell. What I want to do is enter 1005
and in the cell it reads 10:05. I have tried [h]:mm, 13:30, and many other
combinations. It either displays 0:00 or 00:00 or 10/1/1902  12:00:00 AM.

I currently have a cell with the current definition:
=COUNTIF(E9:E200,">1000")
which yeilded the number of cells that have a value greater than 1000. Now
the data in this field has been changed to an alpha numeric string and I

I'm using Excel 2007. I have several values in a certain column, and want to
shade each row appropriately. I'll write it out.
'COL D'
1

Hello Dear experts
1) I have 2 columns (A1:B1000), many of them are colored(red). i want to
delete digit in these colored cells.
2) In above coloumns, i want to delete many of cells with 0.06 (not colored).

I have created an excel that calculates a value based on a number of user
defined variables. The excel is calulating everything correctly. However, I
need the value calculated to remain static since once it has been calculated,
a final user input will chnage some of the variables ...

HELP!!!  
I am trying to create a function that identifies how many times a particular
cell value shows up between dates, then add up the frequency.  I have two
separate functions, that I would like to combine into one.

I have a spreadsheet which is twenty fields (cells) which are all
lookups from twenty different spreadsheet "tables".  So this main page
holds info from 135 thousand plus lines of data, all of which could not
all fit onto one spreadsheet.

I'm new to this group
I've got a "student names" column (about 3000 names) and a "student
comments" column (about 23,000 comments). I would like to replace all names
appearing in "student comments" entries with an X by matching with entries in

I've got =SUM(BDM001!M;M) in C6, ie referring to column M in worksheet
BDM001.  In C7, I want =SUM(BDM002!M:M0, ie referring to worksheet
BDM002, in C8 I want =SUM(BDM003!M:M), etc.  How do I copy down?

I have instrumentation data that i want to calculate r2 regression statistics
but do not have the time to research the steps.  Any help out there?

I'm trying to compare "name" in [sheet1] (where EType.sheet1 = constant), to
name in [sheet2] (where UType.sheet2 equals constant), and write the results
to another sheet.  
The "name" in both sheets is a column list of names which may be duplicates,