Forum Discussion

Southwest Fire's avatar
Southwest Fire
Copper Contributor
Apr 26, 2018

Excel Formula

So I have a gradebook and multiple sheets in the grade book for different categories. I would like to only enter students names once in a separate contact sheet. Can someone point me into the right formula to copy from 2 columns (first and last name) to a single column on another sheet. 

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    Southwest Fire-

     

    maybe try using Vlookup to concatenate the two columns.  You can use it like this:

     

    =VLOOKUP(A5,Table1[#All],2,FALSE)&" "&VLOOKUP(A5,Table1[#All],3,FALSE)

     

     

    Please see the attached file for an example.

     

     

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    Just wanted to follow up and see if you were able to resolve your issue?

Resources