I am trying to create a spreadsheet where I enter a value (x) in a cell on
sheet 1. That value (x) then searches from sheet 2 (a range of values
already entered in). Once it matches the value (x) on sheet 2, I need it to
pull another cell value (y) on sheet 1 and enter it into a column on sheet 2
in the same row as value (x).

Is there a formula that I can create to do this? Any help would be greatly
appreciated.

Thank you.