Hi,

Your question isn't clear, after finding 'Charlotte' in Column A, where do
we look for 'Job seeker'?

Mike

"se7098" wrote:

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.