=Index(Sheet1!A:A;B1) =Index(Range;number row;number column)
| Sheet2
| Sheet1
An image of the function test:enter image description here