Using indirect worksheet functions and vlookups

[AnthonyWB]

Hello everyone. I have the following snippet of code that I use to assign a cell in a worksheet a variable from VBA:

Please Login or Register  to view this content.

It works. I need help creating a vlookup formula which will use that cell refernce. First I have to concatenate the cell reference with the suffix "_CDS", and I must do so while mainting the dating format, dd-mmm-yyyy. Thats is where I am currently stuck. After that is done, I believe I should be using the Indirect worksheet function, but I am not sure how that is done. Any help is greatly appreciated.