In column V of the "HHI as of 4/28/15" file please create a new column and fill it with an index & Title function that will pull over some type of indication if weather the payment for that row is accounted for on the 2nd spreadsheet called "HII Payment Remit Files Found". This 2nd workbook is separated into Tabs by company and the 4 things that need to be matched up are the Date, First name, Last name, and Amount. i dont believe a vlookup function is appropriate here because this has MULTIPLE CRITERIA in which all 4 fields (columns A B C & D on each tab of "Payment Remit Files Found" must match with columns F, D, E, and N on "HII as of 05.28.15" and then in line V your formula will show that it has indeed been found on both. with be in order to confirm each. payment (highlighted in yellow on the Payment Remit Files Found) is accounted for on the HHI as of 4/28/15.
ty and gl
Dear Sir/Madam,
I'm happy to help you on this task. I am an expert in advanced excel skills and have a strong financial background,. If you are comfortable with my ratings and reliability, please send me your existing files to confirm.
I'm ready to start this task immediately and can be finished within 1 hour max ;-)
I assure you that I will go beyond your expectations.
I look forward to hearing from you.
Best regards,
Priyal
I am an expert excel user with excellent hands-on experience in using excel macros and almost every formula.
I can also create a small program if you desire, but for this task i guess index and match formula would be enough though we may be using for other formulas also.
You dont have to pay high for this task, and just contact us.
Will be waiting for your response.
Cheers,
AHK
I have the expertise in Excel and can do this task for you. However i need the other excel files. Its a simple macro which is going to do this task for you.