Pull data from another sheet by reference

[DasOliver]

If I have:

2 Sheets; Data and Filter

"Data Sheet" has:

		A	B	C
1	ID	Name	Lastname	Age
2	OR21978	Oliver	Rodriguez	31
3	SS21979	Steve	Shutte	44

<tbody>
</tbody>

I need in "Filter Sheet" a formula that brings a value to auto complete some cells by reference if I only introduce the ID:


Can you help me?

 

[T. Valko]

If I have:

2 Sheets; Data and Filter

"Data Sheet" has:

		A	B	C
1	ID	Name	Lastname	Age
2	OR21978	Oliver	Rodriguez	31
3	SS21979	Steve	Shutte	44

<TBODY>
</TBODY>

I need in "Filter Sheet" a formula that brings a value to auto complete some cells by reference if I only introduce the ID:


Can you help me?

See if this is what you had in mind:

http://contextures.com/xlFunctions02.html