if formula compare two columns

Hi expert's excel 2007

Need a formula to do the following
If a2 has the word closed and b2 is blank then c2 return ignore ootherwise if a2 is not closed and b2 is not blank then return ref to mapping table
route217Asked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
What do you have in the mapping table, and what does "c2 return ignore" mean? Return C2, or return ignore?

=if(and(a2="closed",b2=""),c2,RefToMappingTable)
0
 
SteveConnect With a Mentor Commented:
=IF(AND(A2="closed",B2=""),"ignore","ref")

or possibly....

=IF(AND(A2="closed",B2=""),"","ref")
0
 
Rob HensonFinance AnalystCommented:
What about the other combinations of options for A2 & B2?

1) A2 = Closed, B2 = blank - Returns Ignore
2) A2 = Closed, B2 <> blank - ?
3) A2 <> Closed, B2 = blank - ?
4) A2 <> Closed, B2 <> Blank - Reference mapping table

You have covered options 1 & 4, could the others occur?

Thanks
Rob H
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.