title: Searching an excel with two search words (multiple lookup) using vba macro
body: <p>I am using vba macros.<br>
  Task: <br>
  1) User will give two inputs viz. number of devices sold (column B) and week number (column A).<br>
  2) Search the excel file using these two and get the earnings.<br><br>
  (Conditions: <br>1. We dont have to modify anything in the excel file.<br>2.And we have to first search <code>devices sold</code> and then we can go to <code>week number</code>.)<br>
  <br>Note: Actually i have a different problem, this is generalization for that.<br><br>
  I used <code>find</code> function but I dont understand why its working.<br>
  <br>
  Please tell what is to be done.<br><br><br>
  Consider the input is <code>11</code> and <code>week 3</code> (so search for <code>11</code> and then check if its corresponds to <code>week 3</code> or not. If not, move to next. I tried this but ended up in an infinite loop.)</p>
  
  <p><br><img src="https://i.stack.imgur.com/oKDQE.png" alt="enter image description here"></p>