CODEWITHSUNDEEP
excelexcel-formulaformulalookup
user6343282
user6343282

Reputation: 31

For the same set of values, how do I pull just one value from a different column in Excel?

For each set of PPIDs that has a “Delete” value and no “Reassign”, how would I populate the Intended Result column. In this example, I only need to populate “Delete” for PPIDS 123 and 789 because there is no “Reassign” value enter image description here

Upvotes: 1

Views: 64

Answers (3)

Mayukh Bhattacharya
Mayukh Bhattacharya

Reputation: 27243

Well, you may try using the below formula as well in cell C2

=IF(AND($B2="Delete",COUNTIFS($A$2:$A$8,A2,$B$2:$B$8,"Reassign")=0),"Delete","")

FORMULA

Upvotes: 2

VBasic2008
VBasic2008

Reputation: 54807

In cell C2 try:

=IF($B2="Delete",IF(SUMPRODUCT(($A$2:$A$8=$A2)*($B$2:$B$8="Reassign"))=0,"Delete",""),"")

Upvotes: 2

Hans Schulze
Hans Schulze

Reputation: 164

Assuming to start at A1 for PPID: B1 cell should contain: if(and(a1=a2,b2=""),"Delete", "") Copy that formula into all B cells. The formulas will adjust the references.

Upvotes: 1

Related Questions