I have one data sheet with information in columns a-j

i have a separate report that i need to populate from the data sheet

i need a formula that will go look for "charlotte" in column a of the data
sheet and if found then find "job seeker" in the same data sheet and if found
return the value listed under "job seeker" to the report

so i think it should be a combo of vlookup and if statements but i am not
familiar with if statements and not very good with formulas.

Thanks.