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?