EXCEL：需要在另一个工作表的单元格范围内查找值，并从相邻单元格返回值

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.I am trying to find the formula that will searc