Darsk,

I think this method has been covered in a couple other posts, but none the less here is a small sheet for you to use as a sample. This method uses vlookup and if to create a dynamic named range. It is a tiny bit laborious, but outside of VBA, I don't know a faster way.

http://www.sociopoly.com/DynamicLookup.xlsx

Cheers