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
|