I have ref no's in Col G (destination File) and the ref No's in the Source File is in Col A.
I also have values in Col H & I in the destination workbook. The values in the source file is in Col J
Where the reference numbers on the destination workbook matches the ref number in the source workbook , and the value in Col I , which is postive is positive and value in Col H <> 0 and there is no match in value for same ref, then I need a formula or VBA code to find the value in Col J that matches Col H that is a few rows above it and extract the Account no. from Col G in same row and place in in Col it in Col M in the destination workbook. Secondly if no match can be found for the value in Col J, then to find the value in Col J that is closest to the Value in Col I and extract the account number in Col G (source file) and place it in Col M in the destination file
Your assistance in this regard in most appreciated
I also have values in Col H & I in the destination workbook. The values in the source file is in Col J
Where the reference numbers on the destination workbook matches the ref number in the source workbook , and the value in Col I , which is postive is positive and value in Col H <> 0 and there is no match in value for same ref, then I need a formula or VBA code to find the value in Col J that matches Col H that is a few rows above it and extract the Account no. from Col G in same row and place in in Col it in Col M in the destination workbook. Secondly if no match can be found for the value in Col J, then to find the value in Col J that is closest to the Value in Col I and extract the account number in Col G (source file) and place it in Col M in the destination file
Your assistance in this regard in most appreciated
