USA: +1 (725) 712-1730 
Sign in
Please help with excel formula:
I would like to write a formula that would give the number “1” in column K if it matches any of the names in column “N”.
In addition, I would like the formula to give the number “2” in column K if it matches of the names in column “O”
General Normal Bad Good Neutral Ca nter. $. %, +0.00 Conditional Format as Formatting Table” planatory Input Linked Cell 00 .0 Number Styles Gen – Action Needed A/L – No Med Pay Gen – Action Needed Gen – Action Needed A/L – No Med Pay VA Pending VA Contact VA – Pending VA Contact Gen – Action Needed Gen – Action Needed A/L- No Med Pay y Gen Action Needed VA – Pending VA Contact A/L – No Med Pa VA – Pending VA Contact I would like to write a formula that would give the number “1” in column K if it matches any of the names in column “N” In addition, I would like the formula to give the number “2” in column K if it matches of the names in column “O”
Expert Answer
Use the below formula,
=IF(AND(VLOOKUP(J4,$N$4:$N$7,1,0)=J4,VLOOKUP(J4,$O$4:$O$7,1,0)=J4), 2,IF(VLOOKUP(J4,$N$4:$N$7,1,0)=J4,1,0))
