I need a formula that will check the position (B1) and if this position is found on the range (C17:C36), it types the players name on "B2", "B3", etc., ordering by pick. For example Column D (TE) must show Engram (D2), Njoku (D3) Legget (D4). Is that possible ?
Solved by X. Q. in 26 mins