VBA - How to write a code for: IF column A = "milk" then column B = "2.50".

[Justyna P]

Hello, I'm a very new (I mean literally an hour) in using VBA and Macros and I'm trying to write my very first if statement. The issue is that when I try on a single cell everything is fine, but I am trying to apply it to the whole column! More specifically - if something occurs in column A then a value pops out in column B next to it. Like when there is a name of product in A then the price pops out in B. Can anyone help with that please?

 

[Logit]

Option Explicit

Sub srchCpy()
    With ThisWorkbook.Worksheets("Sheet1")
        .Range("B2:B" & .Range("A" & .Rows.Count).End(xlUp).Row).Formula = "=VLOOKUP(A2,Sheet2!A:B,2,FALSE)"
    End With
End Sub

The above assumes you are seeking dollar amounts to appear on sheet 1 in column B. The product names are located in sheet 1/column A beginning with row #2. Cell A1 has the term "Product". Your master price list is located in sheet 2 with product name in column A and associated price in column B. Neither column A or column B in sheet 2 has a header.