My objective is to pull the data from the STATUS column in Worksheet 2, as per the pic below...
Pic 1.JPG
And to have that data shown in the VERIFICATION cells of Worksheet 1 (shown in green), by matching against the corresponding email address. So for example, in the case of DAVE JONES, I would want the VERIFICATION column of Worksheet 1 to display 'Invalid'.
Capture2.JPG
To be honest im at a loss as to which function to even begin with so would appreciate help on which function to use and the function calculation itself to get me started. Many thanks in advance.
Bookmarks