|
Complicated Look Up (without making changes to the blank spaces in the table)
1 Attachment(s)
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 |
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 |
Thanks Claus. That what i wanted. Appreciate ur help
|
| All times are GMT +1. The time now is 06:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com