Help with VLOOKUP

[rwilfing]

I have a very simple vlookup formula I am trying to run but everytime I use it it adds a column and puts it in column A then shifts all other columns to the right one.

I am very new to vlookup and wonder if it has anything to do with the fact I am running a Macro to import data?

Thanks in advance

Here is the formula I am using

vlookup($A$2,$O$2:$P$5000,2,0)

 

[rwilfing]

Putting the formula in after i run the macro does not create the same problem so it is definitely related to the macro somehow.

How would I put this vlookup formula into my macro?

 

[Smitty]

How would I put this vlookup formula into my macro?

Put the formula where you want it, the record a new macro and hit F2-->Enter. That will convert the formula to VBA and you can add it to your code.