Thank you for your help. The equation works but isn't returning accurate results. Even though the asin and file name match its returning na NA should only come up if one or both fields are empty.
I've attached snapshots Im not sure why this is so difficult
|