Afternoon

Im currently creating a lookup formula between two worksheets, and would
find it easier to make my formula search within name ranges rather than cell
references. Im having problems making this work though. My current formula
reads.
=INDEX('Communal Areas'!A2:H804,MATCH(E2,'Communal Areas'!D2:D804,0),7)
The name range for A2:H804 is Communal, and the name range for D2:D804 is
Street. When I enter these though my formula comes back in error. I assume
then that I am entering them into the formula incorrectly. Does anyone know
how this should be done?
Thanks in advance.

J.