I was able to record a macro which used a vlookup. The problem I am facing is that the range in the vlookup will change from day to day. How do I set and update the range for the vlookup formula when the macro is run? Please let me know if any information is needed. Thanks for the help.