T
tech1NJ
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
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