3 hours and going crazy transfer from one sheet to another

[Ohaverdw]

Here is my problem, i need to transfer a name from another sheet based on information on the same roll. (sheet2)If information on AI3 equal 1 than transfer name in A3 to sheet 1

Please Login or Register  to view this content.

[José Augusto]

Considere your data in Sheet2!AH1:AI12 (first row has labels)

Try this formula in Sheet1!B3 (or in another cell) and copy down

Please Login or Register  to view this content.