LinkBack URL
About LinkBacks
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
Sheet 2 Sheet 1 john 1 John david DUP Amy Amy 1
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
Sheet 2 Sheet 1 john 1 John david DUP Amy Amy 1
Last edited by 6StringJazzer; 10-11-2018 at 12:29 PM. Reason: code tags for spacing
Considere your data in Sheet2!AH1:AI12 (first row has labels)
Try this formula in Sheet1!B3 (or in another cell) and copy down
Formula:
=IFERROR(INDEX(Sheet2!$AH$1:$AH$12,AGGREGATE(15,6,ROW(Sheet2!$AI$2:$AI$12)/Sheet2!$AI$2:$AI$12,ROWS($A$1:$A1))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks