Refer to the post in General Question
There are 2 lists of value under Column A & B,
Does anyone have any suggestions on how to look up the largest value under
column B and return the value on the same row on column A.

I know this should be simple... but I haven't used Excel in a while
and I can't figure this out.
I have a list of employees, their start dates, and 3 projected dates
(1 month, 3months, 6months).

I'm trying to get somproduct to count every occurance of a word but except
where they match another word. like below it would not count both "problem"
and "solved" but would count every thing else, but it don't seem to be
working, this is how I thought it be written

I have a lookup/match problem that I cannot seem to get a solution
to.
I am assuming I can use a combination IF statement with a nested
VLOOKUP but it's not coming to me.

I know you can find source links in the destination files, but can you find
destination links in a source file?

I am having difficulty coping a worksheet from one workbook to another. The
second workbook being a revision of the first. The revision work was VBA and
not to the sheet itself. I have somehow lost the cell names on the new
revision and need them in order to run the VBA code.

I have a formula like this:
IF(IF('BLDG8'A62='BLDG 7'!A62,networkdyas9'BLDG 8'!c62,'bLDG 7'!c62),
"")=ISERR('Bldg 8'!d74), 'Bldg 8'!74,"")
the first If function returns a "#Value", my attemp on the above function is

Can anyone please let me know how can I add some values in a column
which contains some #N/A.
Thanks.
MH

I've got 2 spreadsheets and I wish to link both spreadsheets this way,
1. Cell A belongs to spreadsheet 1
2. The data in Cell A changes daily
3. I wish to import the data in Cell A into spreadsheet 2 daily

I am trying to calculate how long a machine was down.  Here is a situation.
If a machine went down at 10:00am on 3/1/07. This machine was repaired on
3/3/07 at 2:00pm.  I can figure out the total time it was down which was 2
days, 4 hours (52 hours total).  Obviously, a repairman ...

Is there anyway (without rearranging columes to have my lookup column the
second one i the list.
i.e. I need to look up a number in colume 2 and get the value in column 1
something like vlookup(2,a1:b3,-1)

In one worksheet (RS), I have a list of numbers (A2:A:986). What I want to do
is search another sheet (RD) for every name (A2:A15000) that is associated
with each number (D2:D15000) and have it returned to the original sheet (RS)
on the same row as the number, but with each name ...

If I have a column with numbers and there are both positive and negative
numbers and I want to change all positive numbers to negative in one formula.
I know how to change negative into positive.

I am trying to create a list but the last column has several columns merged.
When i pick create list from my selection it breaks the merged cells into the
original columns and I can merge them back. Is there a way around this? The
list has to sit uner other data but I need more ...

How can I make a cell change colour according to the result of its LOOKUP
formula?
I have put in the following code, but this will only work on cells that
don't have the formula, whereas I need the cells to change colour according