=Index(Sheet1!A:A;B1)
=Index(Range;number row;number column)
| Sheet2
A | B | C |
---|---|---|
=Index(Sheet1!A:A;B1) | =Index(Sheet1!B:B;B1) | =Index(Sheet1!C:C;B1) |
| Sheet1
A | B | C |
---|---|---|
100 | 200 | 300 |
300 | 400 | 500 |
An image of the function test:enter image description here