| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple nest vert
Hi Carlos,
Am Thu, 4 Jul 2013 00:13:24 -0700 (PDT) schrieb : data num A B 01-lug 1 xxxxxx eeeeww 01-lug 2 xxxxxx eeee 01-lug 3 xxxx eee 02-lug 1 xxxxx yyy 02-lug 2 xxxx erer 02-lug 3 xxxx erer I would like that the find.vert, my insert is the data of today and the shift and this tell me the colon B like Insert 01-luglio 2 = it give me eeee 01-lug in F1 and 2 in G1 then try: =INDEX(D1:D100,MATCH(F1&"*"&G1,A1:A100&"*"&B1:B100 ,0)) and enter the array formula with CTRL+Shift+Enter Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I 'nest' multiple quantities from standard stock lengths | Excel Programming | |||
| Need to look up both Horiz & Vert | Excel Discussion (Misc queries) | |||
| 2nd vert. axis? | Charts and Charting in Excel | |||
| Have "IF,Then" to get data from multiple columns--can I nest add'l IF,THENs? | Excel Worksheet Functions | |||
| vert.search | Excel Worksheet Functions | |||
Threaded Mode
