title: EXCEL: Need to find a value in a range of cells from another worksheet and return value from adjacent cell
body: <p>I am trying to find the formula that will search in column A (of worksheet "ABC") to find a value matching G4 in worksheet "XYZ" Once that value is found, return the value of the cell adjacent (column B of "ABC") to the cell in which this formula exists in worksheet "XYZ". All sheets are in the same workbook.</p>
  
  <p>Thank you so much!</p>