Excel 2003 - function to select a value
 

I have created a worksheet with one coloum having a dropdown with certain
types of requests. Trying to create a function, when a request is selected to
link a certain time to a specific request:

example:

If in coloum F I select "prepare a letter" coloum G must show a time of 2
hours. If I then select in the next row "Mail letter" a different time of 1
hour should show.
--
Andrew

Excel 2003 - function to select a value
 

Create a table of lookup values and time and use VLOOKUP, documented in
help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Andrew" wrote in message
...
I have created a worksheet with one coloum having a dropdown with certain
types of requests. Trying to create a function, when a request is selected
to
link a certain time to a specific request:

example:

If in coloum F I select "prepare a letter" coloum G must show a time of 2
hours. If I then select in the next row "Mail letter" a different time of
1
hour should show.
--
Andrew

Excel 2003 - function to select a value
 

Bob

I am born BC (before computers) so I need more help


Colum F Colum G
Request Value
Row
1 Type Letter 2
2 Mail Letter 1
3 Receive Letter


On the drop down in row 4 I then select "Type Letter" in the cell G4 it
should then calculate time of 1 hour. if mail letter is selected it must show
/ calculate for instance 2 hours
--
Andrew


"Bob Phillips" wrote:

Create a table of lookup values and time and use VLOOKUP, documented in
help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Andrew" wrote in message
...
I have created a worksheet with one coloum having a dropdown with certain
types of requests. Trying to create a function, when a request is selected
to
link a certain time to a specific request:

example:

If in coloum F I select "prepare a letter" coloum G must show a time of 2
hours. If I then select in the next row "Mail letter" a different time of
1
hour should show.
--
Andrew

Excel 2003 - function to select a value
 

You need a lookup table to draw from.

In column A and column B

type letter 1
mail letter 2
receive letter 3

In G4 enter =VLOOKUP(F4,$A$1:$B$3,2,FALSE)

Select an item from the dropdown in F4


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 10:53:17 -0700, Andrew
wrote:

Bob

I am born BC (before computers) so I need more help


Colum F Colum G
Request Value
Row
1 Type Letter 2
2 Mail Letter 1
3 Receive Letter


On the drop down in row 4 I then select "Type Letter" in the cell G4 it
should then calculate time of 1 hour. if mail letter is selected it must show
/ calculate for instance 2 hours

Excel 2003 - function to select a value
 

Thank You this helped a lot!!
--
Andrew


"Gord Dibben" wrote:

You need a lookup table to draw from.

In column A and column B

type letter 1
mail letter 2
receive letter 3

In G4 enter =VLOOKUP(F4,$A$1:$B$3,2,FALSE)

Select an item from the dropdown in F4


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 10:53:17 -0700, Andrew
wrote:

Bob

I am born BC (before computers) so I need more help


Colum F Colum G
Request Value
Row
1 Type Letter 2
2 Mail Letter 1
3 Receive Letter


On the drop down in row 4 I then select "Type Letter" in the cell G4 it
should then calculate time of 1 hour. if mail letter is selected it must show
/ calculate for instance 2 hours