Multiple matching & 2 conditions

hsandeep

Well-known Member
Joined
Dec 6, 2008
Messages
1,211
Office Version
  1. 2010
Platform
  1. Windows
  2. Mobile
Column J (J17:J999) & column K (K17:K999) contains values.
In column N starting with N17:N999, I want column K values
PROVIDED
J17= X1 AND
K17 = Y1 AND
J column does not have blank or null filled thr' a formula "" AND
K column does not have blank or null filled thr' a formula ""

How to do this in column N (N17:N999)
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
What do you mean by X1 and Y1.
Can you give a clear example?

To post data:
You can download and install two of the following programs:

HTLMaker

or
Excel Jeanie


or when using Internet Explorer just put borders around your data in Excel and copy those cells into your post.
 
Upvote 0
J17= X1 AND
K17 = Y1 AND

X1 is filled with value eg. SELF
Y1 is filled with value eg. MANAGERIAL.

Now is it ok?
 
Upvote 0

Forum statistics

Threads
1,211,987
Messages
6,105,227
Members
447,957
Latest member
Basildon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top