Multiple If Query

Excel_77

Active Member
Joined
Sep 15, 2016
Messages
306
Office Version
  1. 2019
Platform
  1. Windows
Hi,

I’m struggling with this formula and I was hoping somebody could help.

I’m working on a tab called “workings” and I need to refer to my source tab to check that in this tab the following criteria is met:

Column M = Blank (no information)
Column K – “No”
Column P = “No”.

If the above three criteria are met I want “Yes” returned otherwise I want “No” returned – how do I incorporate this into a formula?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
=IF(AND(M1="",K1="No",P1="No"),"Yes","No")

Thanks, I forgot to add a key part, I need to link the unique ID from the "working tab" within column A to the Unique ID within column A of the "Source" tab.
 
Upvote 0
I think I have made a bit of a mess of my query so I will try again:


I’m working on a tab called “workings” and I need to refer to my source tab to check that in this tab the following criteria is met:

Column M = Blank (no information)
Column K – “No”
Column P = “No”.

Within column A of the workings tab is a unique ID that I need to match to the ID column of the "Source" tab, then if the above three criteria above is met I want “Yes” returned otherwise I want “No” returned – how do I incorporate this into a formula?
 
Upvote 0
So column M K and P are part of the workings tab?

No indication of the "Source" look up cell, I'm assuming A1.
No indication of the range on the workings tab, I'm assuming 1000 rows.
Amend as necesssary

Try
=IF(AND(VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="",VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="No",VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="No"),"Yes,"No")
 
Upvote 0
So column M K and P are part of the workings tab?

No indication of the "Source" look up cell, I'm assuming A1.
No indication of the range on the workings tab, I'm assuming 1000 rows.
Amend as necesssary

Try
=IF(AND(VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="",VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="No",VLOOKUP(Source!A1,Workings!A1:P1000,13,0)="No"),"Yes,"No")

Sorry if that was a little vague - I'm trying a simpler one here now so hopefully this makes more sense.

I'm working in column L of the "RH Working" tab which has unique values from 1-2500 in column A.

I then need to link these unique values to column A of the "Master" tab, once this is done within the master tab I need to search for blank (no entries) within column M, the word "No" within column K and the word "No" within column P, when this is done I want the word "Yes" returned otherwise I want "No" returned. The "Master" tab has 2500 rows.
 
Last edited:
Upvote 0
I cant keep changing this because youre adding bits you havent clearly specified.
Maybe someone else will come along and solve it.
{{moderated: inflammatory and unnecessary remark removed}}
 
Last edited by a moderator:
Upvote 0

Forum statistics

Threads
1,213,501
Messages
6,114,010
Members
448,543
Latest member
MartinLarkin

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