Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupted select option Excel 2003 SP3 | Excel Discussion (Misc queries) | |||
Excel 2003 won't let me select my own regression output range. | Excel Discussion (Misc queries) | |||
Excel 2003 is not letting me select all cells | New Users to Excel | |||
Select by multiple criteria (Excel 2003) | Excel Worksheet Functions | |||
In Microsoft Excel 2003, when I select a color for a cell it does. | Excel Worksheet Functions |