I have a workbook that has three different tabs (sheet1. sheet2 and data) and they have data from column A to AA. My macro below is locating the column header "Car Model" and adding a new column "Type of Car" to the right. Once the new column is added I would want to do a vlookup. Im getting an error when it comes to the formula line. can you please?
Dim Found As Range
Dim LR As Long
Set Found = Rows(1).Find(what:="Car Model", LookIn:=xlValues, lookat:=xlWhole)
If Found Is Nothing Then Exit Sub
LR = Cells(Rows.Count, Found.Column).End(xlUp).Row
Cells(1, Found.Column + 1).Value = " Type of Car"
Range(Cells(2, Found.Column + 1), Cells(LR, Found.Column + 1)).Formula = "=IFERROR(VLOOKUP(V2,data!$A:$W,11,0),"")"