help with vlookup formula

[okcsteve]

When I hard code the lookup value the vlookup formula works just fine. However, when I use a cell reference for the lookup value, vlookup does not work. How can I get vlookup to accept a cell reference for the lookup value?

[Spencer101]

You will need to adjust your thread title to something more descriptive, in line with forum rules.

Also, you may wish to post an example workbook as this will make it far easier to fix the problem.