Pell Lifetime Master report VLookup

 Problem Description : 

How to process the Pell Lifetime Report that Financial Aid sends to do a vlookup with last file.

Master file is on N:\CSD\Finaid Pell Lifetime

 Resolution : 

Instructions for Vlookup on the Lifetime Pell File

1.Go to the PELL_LIFETIME_ELIG_MASTER Excel Spreadsheet

2.Go to a new tab(SHEET 1) right click and rename to next file name

3.Open the PLE file that you just received and copy it

4.Go back to the Master file and paste it into the she sheet you have created

5.Insert two new columns( A and B) on this file

6.On line 1 in Cell one and two title the columns A and B

7.In Column B Cell 2 enter =C2&E2 ( This concatenates the two columns)

8.Highlight cell 2 in column B and copy to the end - SAVE

9.Go to the previous file and note the number of rows

10.In Column A Cell 2 type =vlookup(B2 , prev filename!B$2:B$last column of prev file, 1, false)

Example =VLOOKUP(B2,File9!B$2:B$323,1,FALSE)

11.Copy down to the end of that column SAVE

Those is column A with a #N/A are not on the previous file and need to be worked.

 Revision Date : 10/29/2012