Read data adjacent to Data Validation Source

[Hammer_757]

I’m trying to display the value from a cell next to a data validation source cell. I'm having trouble referring to named ranges while doing this.
On sheet “data Entry” I have dependant Data Validation selection cells “WDdetails” and “WallDetails” (both with green fill in the attached file). I want cell E10 (red fill) to display the value from the cell adjacent to the source of WallDetails.
The data comes from Sheet “Lists”

For example if I select:
“NOT weatherstriped NO storm” then
“W/D one side only”
I want to read .018 (from Lists:C2) in cell E10
It works if in E10 I use formula:

Please Login or Register  to view this content.

However, because I need to expand this data to include more choices I need the array in the first MATCH, “

Please Login or Register  to view this content.

” to be driven by WDdetails, not hard coded.
I've tried a lot to sort this out this weekend and am at the cry uncle point.
This is the closest I’ve come but it gives me a REF error:

Please Login or Register  to view this content.

Sorry for the crazy jargon but I’m trying to keep the terms in line with an old trade document.
Thanks
Robert

[FDibbins]

Hi

It seems it just doesnt like how you are creating that dynamic range on Lists

When I change the range from
=Lists!$B$2:INDEX(Lists!$B:$B,COUNTA(Lists!$B:$B))
to
=Lists!$B$2:$B100, your formula works fine

[ajryan88]

Hi,

Try this formula in cell E10 on the "Data Entry" worksheet:

Please Login or Register  to view this content.

Hope this helps

[protonLeah]

Also, what range of cells is ValData supposed to reference?

[kvsrinivasamurthy]

Pl see the attached file . I feel this is what you want.

[Hammer_757]

Ben, ValData defines the range that contains the Validation Data. this data validation method comes from [contextures.com]http://www.contextures.com/xlDataVal15.html[/URL]
thanks
Robert

[Hammer_757]

Thank you for your help kvsrinivasamurthy. your method worked as you sent it. I made a minor adjustment so I could use just one Valdata named range instead of two. Also I named the header row as you suggested.
Thanks
Robert