#n/a

  1. D

    #N/A error with Lookup and Min functions

    Good Afternoon everyone, I have run into an issue using Lookup with Min. I can use Lookup with Max and get the required results, =LOOKUP(MAX(E7:E1000),E7:E1000,D7:D1000) actually gives the date that matches the Max value. When I change the formula to =LOOKUP(MIN(E7:E1000),E7:E1000,D7:D1000), it...
  2. R

    VLOOKUP and extract #N/A rows

    Hello experts! I hope my question is as easy for you as it seems to me: I've got two tables I'm comparing. Both tables have the index, StudentID, a 10-digit number. I'm using vlookup to compare the tables to find which students are missing from either table (Table A compared to Table B, and...
  3. R

    Disreguard #N/A when adding a column of numbers.

    I have a column of numbers that come from a vlookup. I want to add this column up skipping the cells with a #N/A result from the vlookup. Thanks guys.
  4. I

    Value VLOOKUP is searching for is negative - returns #N/A

    Team, Trying to keep this example simple. I have a pivot table: <tbody> A B C 1 Aisle # Locations Units 2 001 229 1569 3 002 1 -12 4 003 12 214 </tbody> I am trying to combine information in a spreadsheet from three pivot tables using the VLOOKUP. However, when I try to display the...
  5. M

    Return value if there is an #N/A error

    Okay so I have a list of numbers that will be pasted next to an already placed VLOOKUP function, this VLOOKUP will lookup the numbers pasted in another list. This means the VLOOKUP returns a list of all the numbers that already exist in the 'lookup list' and then #N/A if a new number is there. I...
  6. C

    #N/A Values

    <tbody> 1 1 #N/A 2 #N/A 3 2 4 3 #N/A 4 </tbody> I have a bunch of #N/A values in columns. what's the easiest way to get the desired result (1234) in the adjacent column with no empty cells in between?
  7. G

    Formula N/A Error

    Good Afternoon, I'm getting an error with my formula... but only sometimes not every time. =INDEX(DlyRateCodes1!$D$27:$K$455,MATCH($CD11,DlyRateCodes1!$B$27:$B$455,0),MATCH(H$1000,DlyRateCodes1!$D$26:$Z$26,0)) If you could give me an idea of what's wrong, that would be great. I know this is...
  8. H

    Transpose formula returning #N/A in certain cells where values in source data is blank

    I have the following transpose formula which is an array =-TRANSPOSE('C:\downloads\[BR1.xlsm]Summary'!$C$3:$L$3) Where the cells on sheet "summary" C:L are blank , then the formula returns #N/A I have tried using iferror, but get the same result It would be appreciated if someone could...
  9. pcorpz

    help tweaking my formula ifna match index

    {=IFNA(INDEX(PO[Price],MATCH([@[SO Date]]&[@[User Name]]&[@[Item No.]]&[@[SO Qty]],PO[Posting Date]&PO[User Name]&PO[Item No.]&PO[Quantity],0)),INDEX(PO[Price],MATCH([@[Item No.]]&[@[Cost Exact Match]],PO[Item No.]&PO[Sales Exact Match],0)))} My formula works but I know it should be written...
  10. M

    Sumif with index and match if two criteria are met

    Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...
  11. A

    Why this Match is not working, FILE ATTACHED

    Hey guys, can someone tell me please why this file is not working? https://sheet.zoho.com/sheet/editor.do?doc=2f316a5f957451ed09ebbb4a127947ccf5a1467f845cffe4c8a8094a66592afeb433327fda0a94208330b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47 am using (...
  12. N

    Formula problem referencing cells with #N/A

    Hi, I’m trying to create a formula that involves using IF and OR. The problem is that the columns the formula references have a lot of #N/A errors in them, so the result of the formula ends up being #N/A if there is an #N/A in either column H or column I. It just seems to disregard what is in...
  13. V

    Vlookup - multiple columns

    Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...
  14. E

    Vlookup in a string

    I am trying to cleanse a user input list of countries of residence. in some cases the country is hidden in a string of other words like this "kobeshi hyogo japan" I want to lookup from a list of defined countries I have using =VLOOKUP(A4&"*",'country list'!$A$1:$A$165,2,0) but it returns #N/A...
  15. M

    INDEX and MATCH when there are blank cells in column

    I am trying to do an INDEX and MATCH where the INDEX column contains blanks. This formula works well until the column has blanks. Then I get #N/A {=INDEX(O6:O130,MATCH(TRUE,O6:O130<>0,0))} -- Column O returns #N/A =IFERROR(LARGE(P6:P1300,1),"") -- Column P also has blanks, returns #N/A...
  16. leopardhawk

    Index / match

    Here is the data which I am trying to extract the dollar amount in D4 from. <b>Excel 2016 (Windows) 32 bit</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #B6AAA6"><colgroup><col width="25px"...
  17. E

    Formula for counting with two criteria, name and counting for baseball stats

    Guys, I have a baseball team and would like a formula to keep the stats. For example, I would like a formula in Cell F3 that counts how many 1b(from Cell F2) does Salvador Martinez(Cell B3) has in the range B33:F:40. So this formula would need to match B3 and find the rows where Salvador...
  18. M

    Refreshing web query creates #N/A in referencing cells

    Hi, I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries. The order of the formulas is as follows: web query --> cells referencing the table created by...
  19. B

    IF EXACT Formula with multiple chains

    Hello, I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value: =IF(EXACT(G2,"B"),"Btl"),IF(EXACT(G2,"b"),"btl","")
  20. B

    conditional formatting

    is there a conditional formatting rule I can use that would highlight cells A268:d268 in red if F268 is #N/A? the rows will increase that's just where it's at now. I have a Vookup in column F to look at number in column D and it's #N/A people shouldn't add the information but they still do...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top