multiple ifs ands & indirect or offset?

S

se7098

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top