Forum Discussion
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.
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.
Just wanted to follow up and see if you were able to resolve your issue?
