SumProduct withNamed Range using dropdown list

[clng]

Hi all,

Been trying to resolve a "hard-coded" range by using Named Range but has been returning "#VALUE!"

By using the below formula; where range J14 to J2608 is hard-coded, it will work.

=SUMPRODUCT(($E$14:$E$2608="Pipeline")*($H$14:$H$2608=B2)*($J$14:$J$2608))

Similarly, by changing range J14 to J2608 directly in the formula bar with the defined Named Range, it will also work.

=SUMPRODUCT(($E$14:$E$2608="Pipeline")*($H$14:$H$2608=B2)*(Plan_Rev))

But by referring the Named Range ("Plan_Rev") from a cell using dropdown list (see below); the whole thing fails.
In my case, cell "C3" will be a dropdown list that user will select the data they wants this table to return; and I am simulating the return of Plan Revenue.

=SUMPRODUCT(($E$14:$E$2608="Pipeline")*($H$14:$H$2608=B2)*($C$3))

Please help!

Cheers,
CL