I have have been using this formula to identify states within a certain
range.
The sum would return column H and then I Vlookup off the number in I.
Is there a way to replace sum with somehting that returns what is in E
with out the extra step.

{=SUM(IF(L2='State Range'!$F$2:$F$52,IF(L2<='State
Range'!$G$2:$G$52,'State Range'!$H$2:$H$52)))}

Example
E F G H I
AL 2 199 1 AL
AZ 200 399 2 AZ

Thanks


--
Gbonda
------------------------------------------------------------------------
Gbonda's Profile: http://www.excelforum.com/member.php...fo&userid=8758
View this thread: http://www.excelforum.com/showthread...hreadid=504560