To write a formula in excell

There are two sheets with similar data, you need to write a formula: if Sheet1 cell A1 is empty, then search the value of a cell b1 in Sheet1 column b1 of sheet 2 and lookup value from the row numbers where the value is found in Sheet2, cell A1, Sheet1.