I need to confirm that the numbers in Column A (ACORD #) appear in Column E (IMS #). If they DO appear, I then need to compare the date in Column B (Current Version Date) to Column F (Version). If Column B is more recent than Column F, I need a result of "UPDATE NEEDED." If Column B and Column F match, I need a result of "no action necessary." If a number appears in Column A and is NOT in Column E, I need a result of "Form Missing," and if a number appears in Column E and is NOT in Column A, I need a result of "Unknown Form."
I know I need to do a Nested IF with VLookup, but I'm having issues with getting it to work as desired. Can anyone provide some insight on what I should be doing here? The final list has over 900 records, so any help in getting this figured out would be greatly appreciated!
I know I need to do a Nested IF with VLookup, but I'm having issues with getting it to work as desired. Can anyone provide some insight on what I should be doing here? The final list has over 900 records, so any help in getting this figured out would be greatly appreciated!
THEIR # | Current Version Date | Future Version Date | OUR # | Version | |
50AL | 2007/10 | 50AL | 2007/10 | ||
62AL | 1998/05 | 62AL | 1998/05 | ||
90AL | 2015/12 | 90AL | 2010/11 | ||
137AL | 2015/12 | 137AL | 2010/11 | ||
138AL | 2015/12 | 138AL | 2012/04 | ||
290AL | 2014/12 | 291AL | 2010/11 | ||