| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need Help Search and Add
Use an HLOOKUP function in cell A14.
Dave O Eschew obfuscation |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#4
|
|||
|
|||
Quote:
all the best
__________________
Thanks Bala |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file search or search files | Excel Discussion (Misc queries) | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| Functions (search within search result) | Excel Worksheet Functions | |||
| Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Hybrid Mode
