I'm looking for a formula that can do one of two things. Ultimately I don't care which one it does because I can make either of them work but if I had my preference I would prefer something like Solution 1.
I have two worksheets (let's call them SheetA and SheetB) each with the same headers...