title: Excel: Check if Cell value exists in Column, and return a value in the same row as match but different column
body: <p>In a single workbook i have 2 worksheets named Master and Software.</p>
  
  <p>I want to search a range of cells in column F of Software and IF the value '1' exists in it AND IF 'Software' column B has a text value of 'Antivirus', I want to return to 'Master' the cell value of 'Software' column F FOR THE ROW THAT MATCHES THE VALUE 1.</p>
  
  <p>I tried this but i get errors that i can't debug:</p>
  
  <p>=IFERROR(INDEX($Software!F$7:$Software!F$1000,MATCH(1,$Software!A$7:$Software!A$1000,0),1),"no match")</p>
  
  <p>Anyone see what i'm doing wrong please? </p>
  
  <p>It's like a steering wheel down my pants - driving me nuts.</p>
  
  <p>Thanks</p>