title: If cell = #N/A, use another vlookup
body: <p>I have this Excel VBA macro which runs really well</p>
  
  <pre><code>    Sub PCMSLookupTool()
      Dim LastRow As Long
      With Sheets("Lookup Tools")   '&lt;-set this worksheet reference properly
          LastRow = .Range("A" &amp; Cells.Rows.Count).End(xlUp).Row
          With .Range("J10:J" &amp; LastRow)
            .Formula = "=VLOOKUP(A10, 'PCMS-dump'!A:B, 2, FALSE)"
            .Cells = .Value2
          End With
      End With
  End Sub
  </code></pre>
  
  <p>But I need to make it so if it does not find a value (returns #N/A) to run another vlookup ("=VLOOKUP(A10, 'Imported in PCMS'!A:C, 3, FALSE)"</p>
  
  <p>How would I go about to do this?</p>