Hi,

I have two new files...both files have two columns of certainty--Columns C and I. I want to fill Columns A and B in GlobalProject2, with data from GlobalProject. Basically I've been using If/index/Match in hopes of reading files and columns, and then inputting a rep's name into column A in GlobalProject2. It hasn't worked.

My idea is this: Take GlobalProject2 and if there is a blank in Column A, then go to column I and read the Sedol. Once the Sedol is verified, go to GlobalProject and read that Sedol in that Column I. Once that Sedol is read in the GlobalProject file, match that Sedol to who's name is in Column A. Ouput that name to column A in GlobalProject2.

I want to work on the VBA later. For the time being, I am trying to use Excel functions so to learn how combining them (i.e. Index, Match, IF, etc...) can get a project, like this, to work.

I've tried Index, Match and Vlookups, but for me, it's impossible implementing these functions when including multiple columns, criteria and another spreadsheet.

FYI--I filter Column A to show me just the blank cells.

GlobalProject:

Trade Rep SEI Acct BNY Acct Sedol
Christopher Allen 19-502881 12345 B4HKD35
Christopher Allen 6749561649 54321 J894JV8
Christopher Allen 6749561649 45678 B3Y9TB4

GlobalProject2:
Trade Rep SEI Acct BNY Acct Sedol
N/A N/A 12345 B4HKD35
Christopher Allen N/A 54321 J894JV8
N/A N/A 45678 B3Y9TB4

I think this is hard for anyone to solve.

Thanks,

Chris