title: Matching two columns in one sheet to two columns in another
body: <p>I need to assign a status to a row based on a VLOOKUP query between two worksheets. The problem is that the identifier is not always unique. However, the identifier + a date value should be unique. I wanted to use:  </p>
  
  <pre><code>=VLOOKUP(A3&amp;H3,'OtherSheet'!D:E,1,FALSE)  
  </code></pre>
  
  <p>with A3 being the identifier and H3 being the corresponding date. D in the other sheet is the identifier and E is the date column. However, I keep getting #N/A.  </p>
  
  <p>Does this mean that there are no matches with the "identifier+date" or is Excel looking for "identifier+date" in either column D or E? If the latter is true, how can I let Excel concatenate D and E when matching to the search pattern?</p>