Combining two columns if one column satisfies criteria

**nathanwlee** · 02-14-2019, 05:18 PM

Hi

I have two columns I want to create a new column which tells me "Won" if status reason is Won but if not gives me the current sales stage.

What I want this column of data to look like is below

Current Sales Stage (Q)---Status Reason (R)--- COMBINED COLUMN
Prospect---Lost --- Prospect
Prospect---Won--- Won
Prospect---In Progress---- Prospect
Gate 4 ---Cancelled-Customer --- Gate 4
Prospect---Won --- Won
Prospect---Won--- Won
Prospect---Lost ---- Prospect
.....

This is the formula I have tried and it is not working...

=IFS(Q2="Prospect","Prospect",Q2="Gate 0","Gate 0",Q2="Gate 1","Gate 1",Q2="Gate 2","Gate 2",Q2="Gate 3","Gate 3",Q2="Gate 4","Gate 4",Q2="Preferred Bidder","Preferred Bidder",R2="Won","Won")

Any ideas?

**FlameRetired** · 02-14-2019, 05:46 PM

Hello nathanwlee. Welcome to the forum.

I think you will benefit by uploading a representative Excel workbook. Please be sure to include enough data and detail to make things clear. 20 to 30 rows is often sufficient. Show BEFORE and AFTER.

If you are not familiar with how to do this:

To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data

click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”

The file name will appear at the bottom of your reply.

**nathanwlee** · 02-14-2019, 05:58 PM

Cheers Dave fixed now

**etaf** · 02-14-2019, 06:00 PM

i have 365 for mac version 2019 16.22
its working for me

What version of excel do you have

**GeoffW283** · 02-14-2019, 10:36 PM

Isn't it as simple as this?

Formula:

Please Login or Register  to view this content.

It matches the expected results and it even works for us with pre-365 Excel

Combining two columns if one column satisfies criteria

LinkBack

Thread Tools

Rate This Thread

Display

Combining two columns if one column satisfies criteria

Re: Combining two columns if one column satisfies criteria

Re: Combining two columns if one column satisfies criteria

Re: Combining two columns if one column satisfies criteria

Re: Combining two columns if one column satisfies criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Return Data that Satisfies Multiple Range Criteria

[SOLVED] Pull Information From Multiple Columns That Satisfies Multiple Criteria

Increment a cell value until it satisfies a criteria and stop and retain the minimum value

Combining data in multiple columns(all columns have same length)into one column

Help combining two columns, keeping data in first column and date in second column

Identify quantity of unique data that satisfies a particular criteria

A script that satisfies a condition, to change the input column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions