In the Excel table 1, there is a house. I need to enter the room number in Table 2, and automatically jump out the name, area and property fee in different cells.

Suppose that columns A to D of sheet 1 are room number, name, area and property fee respectively.

Enter the room number in A2 of sheet2, and the name, area and property fee listed in sheet 1 will appear in B2, C2 and D2 respectively:

B2 input formula

=vlookup(A2，sheet 1！ $A:$D, column (B:B),)

The B2 formula is copied to the right of D2.

B2: D2 formula copy it down.

In this way, enter the room number in column A, and the following data will come out automatically.