| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Complicated Look Up (without making changes to the blank spaces in the table)
Hello Excel Folks,
Please see attached. I need a formula to do a complicated look up. When you open the file, you will notice some blank cells in the table, which should remain as it is. Just one formula and should be able to drag it down THanks in advance. Excel Dumbo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Complicated Look Up (without making changes to the blank spaces in the table)
Hi,
Am Thu, 18 Oct 2012 02:04:17 +0000 schrieb Excel Dumbo: Please see attached. I need a formula to do a complicated look up. When you open the file, you will notice some blank cells in the table, which should remain as it is. Just one formula and should be able to drag it down in D2 try: =INDEX($I$9:$I$18,MATCH(LOOKUP(2,1/($A$1:A2<""),A:A)&B2,$G$9:$G$18&$H$9:$H$18,0)) and enter the array formula with CTRL+Shift+Enter und copy down Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
|
#3
|
|||
|
|||
|
Thanks Claus. That what i wanted. Appreciate ur help
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a chart complicated | Charts and Charting in Excel | |||
| Making formula too complicated? | Excel Worksheet Functions | |||
| How-To fill down blank spaces in outlined table? | Excel Discussion (Misc queries) | |||
| making a complicated bar graph | Charts and Charting in Excel | |||
| Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
Hybrid Mode
