How to take a value from a cell to the right than the found number?

Question

Google Sheets

For example, there are 2 sheets.
on the first one, the user enters a number in cell A1 and in cell B1 sees the result from the second sheet
; on the second sheet there are 2 columns, in the first the value that the user can specify, in the second the result of the calculation.
How to return to the cell the content located in the column to the right of the found value?

Answer 1

If there is no need to handle errors, then you can insert a query like this into cell B1:
=QUERY('Sheet2'!A1:B6;"select B where A = " & TO_TEXT(A1))