This post is for any other poor souls that can't figure out how to get the values accessed by the CSV Data Set Config configuration element in JMeter into the HTTP Request Sampler (or any other Sampler).
For some reason the JMeter User Manual page for the CSV Data Set Config doesn't explain this.
The key to getting your values used by your Sampler is to reference your values in the sampler in the following format:
This is shown in the screen captures on the left.
Simple when you know how :)