Please help: Vlookup Macro using InputBox Type:=8 to select Lookup_Value

[dherndon3]

Please help! I've looked everywhere. This is my code. I'm using it to input a vlookup formula into the column I designate as "Customer". It's currently looking for the "Serial#" in the Row designated "r". This works fine if there's a column header called "Serial#" but if the header is missing or it has an extra space, the macro doesn't work. I'd like to be able to use an InputBox to click on the cell i need to LookUp and return "B4" in the VlookUp forumla in the "Customer" column. Any ideas?

Please Login or Register  to view this content.

[RaulRodriguez]

Im not certain I uderstand your question, but if you add the following, you will get Serial# issue corrected.

Please Login or Register  to view this content.