Vlookup, changing columns & VBA

[The Student]

Hello. Hope you can help me.

I got the following issue.
I like to do a VLOOKUP based on the column named price. But I have a problem. At work I receive different worksheets and the column "price" can be at a different range (like illustrated in the picture)
I´m making a lot of VLOOKUP and thought it could be nice if a VBA code could identify the Price column and make the VLOOKUP´s in a macro?

 

[mumps]

Please give a little more detail on what you want to do.

make the VLOOKUP´s in a macro

This statement doesn't really tell us much. Explain in detail what you want to do referring to specific cells, rows and columns.

 

[Fluff]

Assuming you only have one Price column on the sheet, try

Sub AddVlookup()
   Dim Fnd As Range
   
   Set Fnd = Cells.find("Price", , , xlWhole, , , False, , False)
   If Not Fnd Is Nothing Then
      Range("G8").Formula = "=vlookup(" & Fnd.Offset(1).Address(0, 10) & ",H:I,2,0)"
   End If
End Sub