formula error

  1. O

    Vlookup() and Index(Match()) returning N/A, even though the lookup value exists in the range and is identical to that value within the range.

    Hi, Thanks in advance for your time. Im trying to match zipcodes in one column with zipcodes in another column in an array, to then return an associated value in another column in the array. I managed to make it work using vlookup with approximate values, but would prefer to use identical...
  2. A

    Index Match Array formula partially working Google sheets

    Hello! I've got a question about an array index match formula that's partially working. So the set up of the data is on sheet2 I have the raw data being downloaded. On sheet1 I have a table with the formulas pulling back only the relevant information from the data dump. The table set up is...
  3. K

    You've entered too many arguments for this function

    My current formula is =IF(D$14>EOMONTH($C15,0)-$C15+1,"NA", IF(OR(DATE(YEAR($C15),MONTH($C15),D$14)<I_ER_START, DATE(YEAR($C15),MONTH($C15),D$14)>I_ER_END),"NA", IF(OR(DATE(YEAR($C15),MONTH($C15),D$14)<C_EMP_START, DATE(YEAR($C15),MONTH($C15),D$14)>C_EMP_END),"NE", IFERROR(...
  4. P

    Using Table Headers as ranges in Data Validation

    Hi Members, I have a table named "Books". My table is very simple with 3 columns. Book.ID, Book.Name, Book.Author All i want to do is to avoid duplicate values in Book.ID column of a table using data validation. I simply used the formula "=COUNTIF(Books[Book.ID],Books[@[Book.ID]])=1". But it...
  5. K

    Data Validation - 15 Minute Intervals - Time Range

    I have a column of cells in which I need users to input their time spent on a project ( time input as [hh]:mm ) the hours are accumulated over a 6 month period so can exceed 24 hours - but I would like the times entered to be restricted to 15 minute intervals (eg. 60:00, 55:15, 43:30, 38:45...
  6. M

    Short formula not returning expected result?

    Hi I've got a formula that searches for two conditions in a cell and if it doesn't find them, then it should return a blank. But it's returning the word "FALSE" instead. What makes things even more odd is that I've written another formula to check if the word "FALSE" appears in that cell...
  7. K


    i just took a class on excel, we learned a bit of formulas so now a day later i am fooling around and trying the new things i learned, however i am getting different results. i made up a quick fake spread sheet, consist of amount of money a individual makes each quarter, i was trying to get the...
  8. N

    Delete Entire Row based ALL Blank Cells and Formula Errors

    I have been exhausting myself trying to appropriately create a macro that delete entire rows in my worksheet A2:LastRow of data based on certain criteria I have been working on creating a macro that deletes entire rows of all data if anywhere in the row there is a blank cell. Unfortunately, the...
  9. S

    Conditional Formatting Based on Multiple Variables - Formula Failing to Register

    Hello, I have been working in a spreadsheet with a really large data set and i need to identify a set based on 2 variables - not date related. Everything I have seen so far has a date in it and I have tried to copy those formulas, but get the error that says, "are you trying to create a...
  10. Whylucky

    A formula contains one or more errors.....

    To Whoever Can Help, I wrote some code in or to create a dynamic graph that uses the attached template sheet. However, i continually get an error message that pop ups whenever data is added or deleted. It is asking to verify the formulas are correct, which i know they are since everything still...
  11. C

    Greater than option (-1) not working in Excel Index Match VBA Formula

    Hello, I am using an Index/Match formula and at the last function when I don't want to match the exact value (0 - because it rarely would) or take the lesser value (1 - because it is not as accurate) the formula usually outputs an #N/A! error when I have the input as -1 as to take the greater...
  12. P

    CountIF Closed Workbook

    Hi, I've read the previous posts however none have really been able to fix the problem I'm having. I have a shared spreadsheet that colleagues use daily (MAILBOX LOG), however I want a master spreadsheet that will pull data from each worksheet withing the MAILBOX LOG worksheet. The current...
  13. L

    Ignore formula if cell is blank

    Hi folks, I have a formula: =VLOOKUP(J8,'Expense Description'!$A$2:$B$29,2,FALSE). When this formula looks at J8 and it's blank, it errors out. I know that there's a way to ignore the formula if there's an error (perhaps with iferror or iserror?), but I don't know the syntax. Since you're all...
  14. H

    Error when entering formula using VBA

    I have a formula that I'm using which works and gives me the right value. =COUNTIF(bommech[PO1 No],"")+COUNTIF(bomelec[Procurement Status],G4) However when I try and enter the exact same formula through VBA using, I get "Run-time error 1004: Application defined or object defined error". I...
  15. M

    Combine 2 lists into 1 w/ no duplicates. Formula/function only.

    I have 2 timesheet lists that are delivered monthly, and the length varies significantly each month. I need to form one list that shows all of the people from both lists... without duplicating if someone is on both lists. I have written a formula that works, with one little hiccup. There's a...
  16. D

    Subtracting DateDif functions from each other

    Hello all, I'm having some issues subtracting one set of DateDif formulas's from another. The formula below works fine in adding a number of date ranges together to output the correct answe in X Years X Months and X days, however I need to subtract a diffrent range of dates and time and the...
  17. M

    Sum formula not working within column (##### error)

    I can't figure out why my simple sum formula of =sum(C2:C46) is all of a sudden returning an error, when it works in the neighboring column just fine. Please help! Thanks.
  18. B

    #name? Error

    I created this formula in 2010 Excel and when I open it up in 2003 I get the error. Please Help! Thanks =_xlfn.IFERROR(U4*K4*L4*M4*0.2835,"")
  19. L

    Help with formula w multiple IFs

    I really need your help! The following formula works: =IF(F7="NR",R7-T7,IF(F7="OR",R7-T7,IF(F7="PR",R7-T7,IF(F7="SR",R7-T7,””)))) I need to add, though, that if there is nothing (no date) in cell R7, then this cell should be left blank. I have the following formula and it's not working...
  20. P

    Formula error

    I have bring value in two adjoining column " Date " in column B by using =VLOOKUP($C$2,'Work Completion Date'!$B$3:$L$354,2,0) " Amount " in Column "C" by using =IF(E28>0,IF(G12=1,Value!$C$57,IF(G12=2,Value!$C$76,IF(G12=3,Value!$C$81)))) and then I try use this results in other...

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
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 "".
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