Excel 2003 - function to select a value

[Andrew]

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.

 

[Bob Phillips]

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]

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

 

[Gord Dibben]

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

 

[Andrew]

Thank You this helped a lot!!
--
Andrew

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