Comparing Cells and Returning Value Hi I think this will be an easy one, but I c

Question

Comparing Cells and Returning Value

Hi

I think this will be an easy one, but I can't figure it out.

The first two columns below indicate methods used to fill a position. The third column indicates which method was ultimately successful.

In the fourth column, I would like a formula that informs that returns the alternate method that was NOT used.

So, the first row should return the value "Certification", the second "No Alternate Used" or some other null value

Is this possible?

Certification

Transfer

Transfer

Certification

Certification

Hiring Method 1 Hiring Method 2 Vacancy Ultimately Filled via Alternate Method?

Explanation / Answer

Hi..

I think the third and fourth scenarios need a modification to your formula:

D2=CHOOSE(MATCH(C2,A2:B2,0),IF(B2="","",B2),A2) or

D2==CHOOSE(MATCH(C2,A2:B2,0),IF(B2="","None",B2),A2)

will address them.

You can do away with the IF function (returns "0") by changing format in Col D./

Hiring Method 1 Hiring Method 2 Vacancy Ultimately Filled via Alternate Method?? Certification Transfer Transfer Transfer Certification Certification Certification Transfer Certification Certification Transfer Certification Transfer Transfer

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.