# if and if then

1. ### How to get the value in multiple criteria of two columns ?

I have data in Sheet1 and in Sheet2. I have three columns in Sheet1 Bank, Branch,Branch Code in A B & C column. In sheet2 I have Bank Branch Code in A B & C column In C2 of Sheet1 I want that IF A2 and B2 matches the criteria it will get the Branch code from sheet2 Range A2:C100. For example...
2. ### excel If and Formula

I want a formula that If J1 is less than 1000 and H1>0 and I1>0 then the value should be 1000-J1 else 0. I am trying this formula but getting error. =IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)
3. ### How to select Exact values under Dependent Rows?

for example I have two Sheets "DATA" "RAW DATA" In DATA sheets <tbody> APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 ORANGE 111 </tbody> In RAW DATA sheet in Column B I have to input APPLE/BANANA/ORANGE in various rows. I...
4. ### Excel Check Vlookup value if cell value matches

I have two Sheets "DATA" "RAW DATA" In DATA sheets Column A COLUMN B APPLE 10 APPLE 15 APPLE 16.5 BANANA 35 BANANA 20 BANANA 36 ORANGE 45 ORANGE 15 ORANGE 50 In RAW DATA sheet in Column B I have to input...
5. ### Help for formula to find Top 3 value in excel

Dear Experts, I am facing problem to make summary sheet of top 3 value from large number of value of my excel sheet like- Sheet1 <tbody> Group Name Value 1 Nashid 200145 2 Kashem 188516 1 Jabed 184198 2 Rubel 172569 3 Romel 168251 1 Eman 156622 2 Hasin 152304 3 Nasim 136357...
6. ### Nested "IF AND THEN" - Need expert guidance please!

I am struggling with a formula and have read (and benefitted) from some earlier threads. However, looking for the elegant solution that may not exist... I'm building a scheduler for a team of 200+ individuals. I have 50K rows of data with a large number of columns. I'm trying to build a...
7. ### Can I create an "If and If, then" for two drop down fields with PARENT values to get the CHILD Values? Quilt?

I'm trying to figure out how to select two values from a drop down list and then to to a table on another tab to pull out a sub value. I have SIZE as a drop down (pulling from a named range) I have COLOR as a drop down (pulling from a named range of parent colors, which have child colors)...

### This Week's Hot Topics

• Use Filter function with 2 criteria to return a specific value
I've spent many hours trying to find out why the basic formula for Filter function with 2 criteria will not return a value other than #CALC. I'm...
• Loop stopping at row 10
Below is a code I had a lot of help with from user such as yourself. This code worked well but now is stopping a row 10 and I can't see why! Could...
• Numerical Order Code for Macro
I am trying to find a code or fix what i have on the macro that will automatically make the certain column generate in numerical order when I...
• Calculate time in excel
I get a text report from our time keeping system that i dump into excel through a data connection and I need to calculate the total hours for a...
• VBA
Hello everyone, I need your help please. I just need VBA code to get my reports working. What I want to do is whenever these dropdowns are...
• Help with formula to sum numbers prior to date
Hello, I was hoping to get some assistance as I'm having trouble with this. Using my table below as an example, how could I write a formula which...

### 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

### 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