Re: Formula to compare 2 new lists and return a Value
As per your worksheet data. I tried using this formula .
Please do not quote entire posts. When quoting follow these guidelines
1. Quote ONLY if it is needed to add clarity or context for your reply. If so, then
2. Quote ONLY the specific part of the post that is relevant - - not the entire post.
This will keep thread clutter to a minimum and make the discussion easier to follow. Quote deleted.