Thread: Syncing data between two excel workbooks using multiple criteria
View Single Post
 
Old 04-21-2016, 09:31 AM
Merlot Merlot is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Dec 2015
Posts: 7
Merlot is on a distinguished road
Default Syncing data between two excel workbooks using multiple criteria
Good Day,

I have an extensive database from which monthly reports are generated and sent to various officers for their comments, after which the comments have to be inputted back to the master database. I cannot (or do not think I can) use VLookup because there may be multiple periods with similar data so I need to use 3 fields as the search criteria (Name of Borrower, Financial Report and FYE/ Period). The information has to be inputted in the column labeled Comments.

Can anyone assist?
Reply With Quote