In Google sheets use Value from a Cell ( retrieved with =MATCH ) to get Information from another sheet

Question

Im new to google sheets and might be doing this all wrong. Im trying to get information from another sheet by using the value from a cell in my current sheet.

In the current sheet, I have a column of IDs This is populated by looking at the Data sheet and finding "foo" and returning the row number

=MATCH("foo",Data!A:A,0)

This will return 2 for example

I would then like to use this number to reference a cell in data sheet

=Data!E2

I would thought it can be done with something like this

=Data!E=MATCH("foo",Data!A:A,0)

Answer 1

use:

=INDIRECT("Data!E"&MATCH("foo", Data!A:A, 0))