How can I fill-in blanks from one spreadsheet using data from another?

[ctallen23]

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

 

[SirJB7]

Hi, ctallen23!


First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.


As a starting point I'd recommend you to read the three first green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).


Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.


Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.


And about your question...


Consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you. Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!