Solved

if formula compare two columns

Posted on 2014-03-27
3
101 Views
Last Modified: 2014-03-30
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
0
Comment
Question by:route217
3 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 250 total points
ID: 39959089
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
 
LVL 7

Assisted Solution

by:Steve
Steve earned 250 total points
ID: 39959125
=IF(AND(A2="closed",B2=""),"ignore","ref")

or possibly....

=IF(AND(A2="closed",B2=""),"","ref")
0
 
LVL 33

Expert Comment

by:Rob Henson
ID: 39961212
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

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question