Need Help Search and Add

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to repeatingly sum the next n cells? 4
finding greatest (or least) date associated with given value 2
Merge data from two separate tables 1
Move cells down to match cells 3
Need Major Help on the Macro 12
Data Entry - Write to next cell 3
How to use indirect function? 6
Move cells down to match cells 1

Top