Need a formula in Google Sheets?

Question

excel

there is a column with order numbers on the check sheet, on another sheet this order number is located with the rest of the data, you need a formula that will find the order number in the main sheet and pull out the payment amount that is indicated at the very end (second screenshot)
(check sheet) (main data sheet)

Answer 1

The VLOOKUP formula will help you.
https://support.google.com/docs/answer/3093318?hl=ru
Look at the description on it, there are many examples on YouTube.