title: Excel Vba getting value of cell and setting a string
body: <p>I want to set a string as a certain letter based on the value of a cell. The cell should only have the values, "P1", "P2", "P3", "P4". If the cell is "P1" then I want to set the string "products2" as "a", if its "P2" I want "products2" set as "b" ...</p>
  
  <p>Here is the code, which will get the correct value for the cell, but wont use it to set the products2.</p>
  
  <pre><code>Dim Products As String
  Dim Products2 As String
  
        Products = wash.offset(1, 3).Value
  
              If Products = P1 Then
                  Products2 = "a"
              ElseIf Products = P2 Then
                  MsgBox "we got here"
                  Products2 = "b"
              End If
  
              MsgBox "products2 = " &amp; Products2
  </code></pre>