Prev: Convert dates stored as text
Next: Recording and playing Macro (Solver)
From: tech1NJ on 21 May 2010 17:17
Have a 2 rows of cells (5 and 6) with data. Row 5 has letters A through S.
Row 6 has years 2001 through 2018. In addition, I have Cell A14 where I would
like my users to type a letter from A through S. Based on the letter entered
in A14 I would like excel to search row 6 and find the correspondant year and
enter it in A7.
Is there a way that this can be done. Thanks in advance.

See a basic example below
Row 5 has A B C D E
Row 6 has 2001 2002 2003 2004 2005
Row A7 = 2002
Row A14 - User Enters B
--
tech1NJ
From: Dave O on 21 May 2010 18:13
Use an HLOOKUP function in cell A14.

Dave O
Eschew obfuscation
From: tech1NJ on 25 May 2010 10:00
Can you elaborate on this HLOOKUP more please
--
tech1NJ


"Dave O" wrote:

> Use an HLOOKUP function in cell A14.
>
> Dave O
> Eschew obfuscation
> .
>
 | 
Pages: 1
Prev: Convert dates stored as text
Next: Recording and playing Macro (Solver)