multiple ifs ands & indirect or offset?
 

I need to populate a master spreadsheet from a source file of raw data.

I need a formula that will look first for the city, then for the job code
then if both match then return the corresponding value for each of the
folders...

i.e., look for atlanta...if found then look for job code 12345...if found
then return value of inbox here; value of interview here; value of selected
here...etc.

is that possible? i have played with ifs & ands etc but cannot make it work.


the raw data is in a spreadsheet set up as follows:

Inbox Interview
Selected In Process Hired
City State Job Code Recruiter 361 49 22
16 10