title: Excel VBA Macros: Find/Match cells from one sheet to a column in another
body: <p>Ok, so I have a workbook with multiple sheets.  The Worksheets are named:</p>
  
  <p>Inputs
  Outputs
  Hardware</p>
  
  <p>Input and output are serial IDs matched to actualy IP Addresses.<br>
  Input 1 : 192.168.0.1
  input 2 : 192.168.0.2
  ... etc</p>
  
  <p>Hardware has 3 columns.  The first has Devices, 2nd column which has the Input Serial IDs and the 3rd of Output Serial IDs.</p>
  
  <p>Toaster : Input 1 : Output 3
  Blender : Input 2 : Output 2
  ...etc</p>
  
  <p>Now, normally, I'd be using Vlookup(A1,Inputs!A:B,2) and Vlookup(A1,Outputs!A:B,2), but I have to incorporate this into the VBA macro we have and I have no idea how.</p>
  
  <pre><code>Sub TrackHardware()
  
  '~~~~~~~~~~~~~~~~~~~~~
  'Activating Device
  '~~~~~~~~~~~~~~~~~~~~~
  currentOutputRow = 2
  Dim test As String
  
  
  For currentRow = 2 To 32768 'The last row of your data
  'For Loop to go through contents of Hardware individually
  
      If Not (IsEmpty(Worksheets("Hardware").Range("A" &amp; currentRow).Value)) Then
          'To Skip the empty cells 
  
              HWID=Worksheets("Hardware").Range("a" &amp; currentvalue).Value
              'HWID is the search term coming from Sheet:'Hardware'
  
              Desc=Worksheets("Hardware").Range("D" &amp; currentvalue).Value
              'Desc is the Plain Text description coming from Sheet:'Hardware'
  
  
  
              inputrow={Match pseudocode that didn't work(HWID, "Inputs", Range:= "A:B", 2) }
              outputrow={Match pseudocode that didn't work(HWID, "Outputs", Range:= "A:B", 2) }
              'trying to find the row # of search term in Sheets 'Input' and 'Output'
  
              Worksheets("Inputs").Range("C" &amp; inputrow).Value = Desc
              Worksheets("Outputs").Range("C" &amp; outputrow).Value = Desc
               'Pastes The Device Description to Input and Output Sheets
  
  
  
      End If
  Next currentRow
  'And on to the next line in 'Hardware'
  
  End Sub
  </code></pre>
  
  <p>I'd also like to account for Errors like 2 devices on the same Input/Output or a Blank cell, but I think I can figure those out myself.  This Find function is what's really giving me a lot of trouble.</p>