Question: how to get data from one excel sheet to another using formula?
Answer: Select cell C3 and click on it.
Insert the formula: =VLOOKUP(B3,'Sheet 2'!$ B$3:$C$7,2,0)
Press enter.
Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.