title: Lookup or If Condition Formula in MS Excel
body: <p>I need some help for a lookup formula in excel sheet. I am basically trying to find out a corresponding value of for a row, where two conditions in the same row meet. Let me illustrate it his way. If within the range of column A a certain value is found and in the same row but in Column C other certain value is equal then return the value in Column B for the same row.</p>
  
  <p>The table is as follows:</p>
  
  <pre>
  Column A      Column B                        Column C 
  ---------------------------------------------------------
  Ahmadaba      Irrigation                      550,041 
  Ahmadaba      Livelihood                      18,890 
  Ahmadaba      Power                           233,694 
  Ahmadaba      Public Building                 64,707 
  Ahmadaba      Rural Development               104,381 
  Ahmadaba      Transport                       1,044,644 
  Ahmadaba      Water Supply & Sanitation       1,156,322 
  </pre>
  
  <p>To elaborate; in reference to above table if Column A is equal to Ahmadaba and Column C is equal to 18,890 then I should get the value Livelihood from column B. </p>