Excel 2007 : Help with a complicated lookup/reference array formula...

I don't really know how to appropriately title this thread.

I'm having a problem with this formula...I got it from another thread in here and changed it to suit my needs. It has been working fine exept for one flaw I can't seem to figure out...The problem is, if a value in A2 does not match any values in the table area (B5:G10), a false result is returned. In this example sheet that result is the first row title. I would like it to read blank if a value cannot be found if possible...thoughts?

I built a sample sheet with the below formula.

Please Login or Register  to view this content.

Typos in the code - replace A1's contents with:

Please Login or Register  to view this content.