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
Hello Sir,
Im excel VBA macro and Formula Expert :)
im familiar about index and match function in excel :)
please give me a chance for doing your job and im able to start doing your job right now :)
Thank You
Sincerely
Prameswara :)