Find cell value that matches from one tab to another. If theres a match return the value in the right cell

Find cell value that matches from one tab to another. If theres a match
return the value in the right cell

I have two tabs in an excel work book.
Named Sheet2 and one named $.
I would like to match the cell contents in cell B2 (Sheet2) which is a
product ID, in tab ($) in the range if cells A2:A1800. If there is a match
i would like to return the value of the corresponding cell on tab $ next
to the right of the matching cell (this is the price of the product ID)
Ideally i'd like to use a vlookup or a function