Hi there have a problem and don't think Vlookup helps me much.... i attached a sample of what I have.
I basically have to reports with the same account number (column A) in sheet 1 & 2 but the person responsible (column B) might be different. I'm not sure what formula I can use so I can be notified which loans have a different person in charge....
Bookmarks