ifs and lookups

  1. 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...
  2. 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...
  3. 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...
  4. S

    Flagging if cell found within list then checking if date is greater than that in list

    Hi all, I'm having a tough time flagging rows that match the values within a list and also have dates that are greater or equal to those dates that correspond to the names in the list. See example below: List: <tbody> U V 1 Name Date 2 A 10/01/15 3 B 10/02/15 4 C 10/03/15 5 D...
  5. C

    IFs with multiples criteria

    <tbody> Cost per month %Allocation Start Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1000 50% 1 </tbody> Hi everyone, I hope you can help me with the formula. My logic is if Start month = 1, then Jan - Dec = Cost per month* %Allocation if start month = 2, Jan = 0...
  6. V

    SUMIFS alternatives to return text

    I have a vast amount of data, and I want to return a specific cell's text value if certain criteria in other columns are met. I can use SUMIFS to get it to work for values (numbers) but cannot apply a similar theory for text. Probably easier explained by much simplified example below... I feel...
  7. D

    if and VLOOKUP formula help

    Hi I have been wracking my tiny brain all day and cannot figure out what I am doing wrong. Basically my formula needs to do the following: lookup a value in a set column according to ID number and if this is blank to leave blank and do nothing else, if not blank to lookup another column...
  8. E

    Combining HLOOKUP and IF statements

    Hey all, I am stuck on this formula. So I created key to lookup and match a type a for a month to get a value. Some the keys do not have a value (meaning key is non existent) for a month so it returns as #N/A in the cell. This is the lookup formula I have...
  9. H

    pulling down empty cells

    Hi, I have a spreadsheet which has orders on, when one person has placed one order, the personal info and order come up on one row. However my problem is when someone places more than one order; this is because the personal info is on a row and the order(s) the rows below. What I need is some...
  10. K

    mulitple IFs

    i have a spreadsheet that does a vlookup if cell A7 has text in it which i want to display as a hyperlink the formula below works great but i dont want it to display anything if the vlookup does not contain any text so i have been trying to insert another IF in the vlookup but cant get it to...
  11. N

    How to List - Automatically

    If sheet A consist of a list like this: <table height="138" width="423" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:2998;width:62pt" width="82"> <col style="mso-width-source:userset;mso-width-alt:3328;width:68pt" width="91"> <col...
  12. J

    Very Detailed IFs and VLOOKUPs Help Needed

    Or it could be solved through VBA but in any case i'm well and truly stuck and I need to get this project finished by Thursday (Meeting the boss and plan to take this with me) so therefore any help is much appreciated. I have a copy of the spreadsheet (with the sensitive info amended to random...

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