Need Help Search and Add
 

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

Need Help Search and Add
 

Use an HLOOKUP function in cell A14.

Dave O
Eschew obfuscation

try sumif function, i have attached excel file with your data.

all the best

Need Help Search and Add
 

Can you elaborate on this HLOOKUP more please
--
tech1NJ


"Dave O" wrote:

Use an HLOOKUP function in cell A14.

Dave O
Eschew obfuscation
.