FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I have a macro that uses VLOOKUP to pull values from an older version of a spreadsheet on a newer version to look for differences in the values. I then filter for any differences over 0. It works perfectly if there is an exact 1:1 match for the VLOOKUP values. Sometimes, though, the newer data will have a value that isn't in the original data, and the VLOOKUP will leave behind #N/A.
So, I need some code that will look for #N/A in Columns L and M and replace with the offset value from the same row in Column J. For example:
Should look like this:
Can anyone help?
I have a macro that uses VLOOKUP to pull values from an older version of a spreadsheet on a newer version to look for differences in the values. I then filter for any differences over 0. It works perfectly if there is an exact 1:1 match for the VLOOKUP values. Sometimes, though, the newer data will have a value that isn't in the original data, and the VLOOKUP will leave behind #N/A.
So, I need some code that will look for #N/A in Columns L and M and replace with the offset value from the same row in Column J. For example:
Rank Final Incentive | FW User JF Concatenate | Login User Id | Fiscal Week | Emp ID | Autolink File Num | Pay Grp | Earning Code | Incentive Job Function | Final Incentive Payout | Original | Difference | |
17aboydBAG PICK | aboyd | 17 | BAG PICK | $25.21 | #N/A | #N/A |
Should look like this:
Rank Final Incentive | FW User JF Concatenate | Login User Id | Fiscal Week | Emp ID | Autolink File Num | Pay Grp | Earning Code | Incentive Job Function | Final Incentive Payout | Original | Difference | |
17aboydBAG PICK | aboyd | 17 | BAG PICK | $25.21 | $25.21 | $25.21 |
Can anyone help?