How to do a match search and cell merging?

Question

excel

You need to take records from column B in turn, then insert data from C and D into the matching row A. That is, A1 should be equal to House 1; 4444: qwer

Answer 1

Cell A1 cannot be a condition and an answer at the same time. Therefore, formulas for the solution cannot be found.
You need to consider the option of writing the answer in another column, and then copying it to column A.
In this case, the VLOOKUP formula will suit you
. Macro can also solve this problem.