ifs and lookups

  1. N

    Multiple sheets, multiple criteria formula excel 365 and Google sheets

    So after many hours and lots of assistance I am nearly there. What I would like now is the following, this is my current formula: =SUMIFS(Group1!$N$3:$N,Group1!$D$3:$D,"<="&$B$14) I would like to add to this formula is 3 more criteria. That formula is in H14 and I would like to add H13...
  2. N

    IFS, SUMIF and INDEX

    I have two formulas that work perfectly but I want to add another if (I think) element to the formula. I have just got a small sample of data and based on the small sample its not worth trying to find a short cut but when you have 100 data sets and 500+ rows of data. So what I am wanting is on...
  3. N

    Sim if with conditions

    Hi I want a formula that will sum data in a range based on a set criteria and I’m struggling. I have 1 - 100 data sets that I want to total 3 different columns with. Currently my formula reads = sumif(acc!$d$4:$ec$4,’FWD’,acc!$d5:$ec5) and that’s working to give me the total for all 100 data...
  4. J

    Populate data from different sheets into 1 page based on criteria

    Hello - I am having some trouble on how to automate excel to grab bits of data from cells in other sheets (same workbook) and bring it into a single page summary. For example, I am wanting to populate this table and based on what serial number is typed in (B-002 etc), the table below will...
  5. D

    Display Results Matching Search Criteria, Ignore Blanks

    I have a sheet called "Data" that contains many rows of information in columns A to K. I have a sheet called "Search" where I have this: The user can fill in the search fields (as many or as few as they want). These fields are named: C2 = "Agency" C4 = "User_ID" C6 = "Surname" E6 =...
  6. A

    Need help with either Conditional formula or VBA script to solve issue

    Hello I am having an issue figuring out how to get my duty excel spreadsheet to do the below and am looking for either a formula or VBA based solution: Basically I have the below spreadsheet and if there is a value in the additional duty column (starting at I5) I would like the value to be...
  7. W

    Need help to find correct formula! Multiple criteria and range levels

    Trying to come up with a formula for a Sandbox that calculates an employee bonus's Criteria 1 - Type of Mgr - These 2 levels receive bonus based on % variance to budget * General Mgr * Asst Mgr Criteria 2 - Type of Mgr - These 2 levels receive bonus based on Store Level Sales (4 levels of Low...
  8. A

    IFS with addition? Help Please

    I am looking for a formula that will add 180 days to G3 if the answer to E3 is NO with the result put in H3, if the answer is yes put the date in F3 with the result put in H3. I have uploaded a screen shot for reference. Thank you for your help!!
  9. A

    STD Deviation Discrepancy

    I am trying to find the standard deviation for data presented in different ranges and I am currently using the following equation: =+STDEV.S(IF((e7a1!A12:A1010>=Primary!K$5)*e7a1!A12:A1010<=Primary!K$6);INDEX(Table1;0;MATCH($D19;Table1[#Headers];0));)) The reason for the formatting is that its...
  10. C

    Show cell value based upon data contained in column below

    Hey all, I'm trying to work out the best formula to use for the below requirements. I have my sheet below, I'm looking to show the top field (row 1), if there is any amount within the corresponding columns below, into a new column. What formula am I best working with? This could extend to 20+...
  11. M

    IF and VLOOKUP statement - not working

    Hello Everyone! I am looking to create a formula to do the following.. If C14="THIS" then look in table on page 2 (columns B-F) for data in Cell E23(from page 1) and return pricing listed in column 3, but if Cell C14="THAT" then look in table on page 2 (columns B-F) for data in Cell E23 and...
  12. S

    Summarising a calendars events with lookups and ifs

    Hi all, I am trying to create a summary of a sort of calendar I have made. The calendar is a daily view and runs landscape, with the days/dates (custom formatted to just show the day i.e. d) at the top and then with the task/meeting categories to the left of this (column A). I want to summarise...
  13. P

    Return last value of a row based on another value

    Hi, I have written the following formula: =INDEX('Daily Breakdown'!AD1:AD1000,COUNTIF(('Daily Breakdown'!AD1:AD1000),"<>0")) this returns the last value in column AD which is not 0. However I want this to return the bottom/last value based on the value in column B So if column B is equal...
  14. P

    Date If Formula

    Hi, I would like to write an If Formula (think combines vlookup too) I would like to say if todays today is displayed in x field return the value in y field, if not repeat the formula for yesterday date so like today()-1 etc and repeat this for 2,3 todays.
  15. P

    Array formula (think index, match)

    Hi, Got an issue which is complicated so I hope this makes sense :) I want to write a formula in a spreadsheet saying if the value in column a (tab 1) is equal to that from the range in column a (tab 2) then check column S for the most recent value (date is in column B (tab 2)) and return...
  16. J

    comparing 3 columns with VBAI

    I need to setup code that compares 3 columns. column C will have comparison values. I am trying to compare column C to D. If column D value is matching C, column F should be greater than 1. If not I would like to prompt user "Please put greater value in column F" and exit out of the code. Is...
  17. S

    Generating leadsheets

    I have a workbook in which I will have multiple tabs. Tab 1 looks like this. Let's call this Tab - ALL. The common thread is the group name: I will create a second tab called "cash" and have a A1 also be called "cash" I want to then prepopulate this second tab with all accounts...
  18. R

    Help! Multiple Criteria

    Hello everyone, hope all is well. I will be making a presentation – automated gathering of info. I just can’t figure out how to make this happen. The first spreadsheet would be the output, the date on the top are the ship dates. I have customers that are ordering 2 items irregularly, need to...
  19. G

    Index, Match and IF Statement Help-

    Hello I am having issues with the following: I have two data sets. Both contain transactions and neither have unique values. Data set 1 contains Truck, and Toll Transaction Date/Time. Data set 2 contains Truck, Order Number, Dispatch Date/Time, and Empty Date/Time. I am attempting to index the...
  20. R

    Sum / index matching

    Hi All, For the life of me I cannot think of a function I can make work to sum the totals of various products against a unique reference code. Basically I want to to know how much in total of each product I need to purchase from summating Volumes in Column E and giving output in column E...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top