Yeah I see your point , but thank fuck they didn ' t release the full game this month and delayed it because they knew the game wasn ' t ready . <| sep |> Correct . INDEX $ A $ 1 $ A $ 18 , MATCHD 1 , $ B $ 1 $ B $ 18 , 0 This will return each number based on the letter in cell D 1 , D 2 , etc . I ' d put this formula into E 1 and drag it down . You will then have a list of matches in column E . Then column F would be a simple CONCATENATED 1 , , E 1 Which is your letter reference , followed by a space and the lookup you have just found with INDEXMATCH . <| sep |> Yes , I suppose 2016 actually deserves a worse fate . But we can ' t be cruel . <| sep |> Hey , given the political insanity of 2016 , maybe by 2020 we ' ll have Martin Sheen running for president in character as Bartlet !