Hello,

I am almost done making my excel sheet that I've been working on for 2 weeks. When I'm going through finishing the design of the worksheet I keep running into a very frustrating problem. I have a cell that uses Vlookup to pull data from another sheet. The cell is C5 that has the data in it, but I'm trying to merge it from C5:G5. When I merge and center the text that the formula displays disappears. I've tried moving the cell and that doesn't seem to work either. To add to the frustration, I can't get the border to show up on the right side of G5 either. Does anybody have any experience on trying to fix this? Thanks!