if statement - excel and mechanical turk -

i trying search identical strings in different columns , cells of same excel worksheet. specifically, trying use approve people mechanical turk. copy , paste list of people's mturk id's downloaded csv file (from mechanical turk) use approve people. add 2 columns @ end of downloaded csv file, mturk id , 1 or 0, indicating whether should approved. trying write function search 2 columns contain mturk id's, if there 1 or 0 next id, thereby indicating whether should approved or not. can please me?? assume can done if statement. not familiar vba, unfortunately.

it sounds need vlookup function lookup 1 or 0 list of ids. way vlookup works looks value (like mechanical turk id) in range of data , returns piece of data on same row found match.

as example, if had data in set of cells, let's column had mturkid, column b had last name, c first name, , on, , had lookup ids , 0 , 1s in range of cells t1 u10 (say list of 10 ids example's sake), insert vlookup in column right of data (let's column d in example). like:

=vlookup(a1, t1:u10, 2, false) 

the first parameter value want (the mechanical turk id). second range in want id--the potential matching ids have in column t--the first column in range identify, , column u have 0 or 1. 2 tells want return second column in range of data, in case 0 or 1 in column u. false tells want exact , not approximate match (i've never found reason use approximate match, use false here).

if doesn't make sense, google vlookup, , should find lot of examples , more information.