View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default 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