Automatically Adding Time based on a name ranged
 

I have a named range ---

178 1:45
5969 2:00
48 1:30

The table I am working looks like

A B C D
178 Contract A 2/3/08 8:00 am
5969 Contract A 2/3/08 9:45 am
48 Contract B 2/3/08 11:45 am

In column D row 1 , I would input a time.

In column D row 2, the formula would look at column A row 1, and match it up
in the named range, then add those hours and minutes to column D row 1 time
and give me a new time.

HELPPPPPPPPPPPPPP!

Automatically Adding Time based on a name ranged
 

In d2, use:

=d1+vlookup(a1,$NamedRange,2,false)

Regards,
Fred

"Cathy" wrote in message
...
I have a named range ---

178 1:45
5969 2:00
48 1:30

The table I am working looks like

A B C D
178 Contract A 2/3/08 8:00 am
5969 Contract A 2/3/08 9:45 am
48 Contract B 2/3/08 11:45 am

In column D row 1 , I would input a time.

In column D row 2, the formula would look at column A row 1, and match it
up
in the named range, then add those hours and minutes to column D row 1
time
and give me a new time.

HELPPPPPPPPPPPPPP!